Results 1 to 5 of 5

Macro to protect only one sheet

Threaded View

Crüe Macro to protect only one... 08-17-2011, 02:00 AM
royUK Re: Macro to protect only one... 08-17-2011, 02:14 AM
Crüe Re: Macro to protect only one... 08-17-2011, 02:26 AM
royUK Re: Macro to protect only one... 08-17-2011, 02:28 AM
Crüe Re: Macro to protect only one... 08-17-2011, 02:34 AM
  1. #1
    Registered User
    Join Date
    08-05-2011
    Location
    Kaavi
    MS-Off Ver
    Excel 2007
    Posts
    45

    Macro to protect only one sheet

    Hello,

    I have created memo that has one sheet called "Memo", it contains activex-objects, textboxes and drop down boxes. One object is called "Add new sheet", when I run this macro, it opens new sheet, a copy of this sheet "Memo".

    What I need is a code, that prevents user to select this "Memo"-sheet. I've tried to hide it but then, if I try to add new sheet, macro won't work, new sheet comes also hidden and whole book "breaks apart".

    "Memo"-sheet doesn't need to be hidden, I just want to protect it that user cannot do ANYTHING into it. I've also tried to protect whole workbook, but it won't help 'cuz activex-objects won't lock, I checked at object-properties and all them are "Locked", but still able for user to select.

    And one last question. Because of that these new sheets are copies of this sheet *Memo", and if this "Memo" is fully protected and THEN copied, these new copied sheets become also protected (??) What can I do that this "Memo" is protected, and when I copy it, new sheet comes UNprotected?? Anyone understand what I'm talking about.... ??

    Help me please!
    Last edited by Crüe; 08-17-2011 at 06:51 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1