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!