LinkBack URL
About LinkBacks
When I protect workbook, activex-objects (commandbuttons, textboxes etc.) can still be selected. I have a tab on "Locked" in object-properties but it doesn't help. How can I protect these objects that they cannot be selected?
When I protect workbook, activex-objects (commandbuttons, textboxes etc.) can still be selected. I have a tab on "Locked" in object-properties but it doesn't help. How can I protect these objects that they cannot be selected?
Last edited by Crüe; 09-05-2011 at 02:31 AM.
Hello Crüe,
If you can not select an ActiveX object then it becomes form without function. You have to be able to select the object before it can perform an action. Did mean prevent it from being deleted?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Yeah, I try to prevent it from other users, so that they cannot delete it neither select. They can select these objects only when workbook is Unprotected, but when its protected, they shouldn't be able to select nor delete anything.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks