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!

You can't hide the sheet if it is the only one in the workbook.

Add this line to your code after the sheet has copied

Please Login or Register  to view this content.

If you have a password then

Please Login or Register  to view this content.

Originally Posted by Crüe

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".

My suggested code will unprotect the new sheet