Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a protected worksheet with some macros I'm creating. The macros
call the Protect Userinterfaceonly:=True to be able to modify the sheet, but there are still some problems: - I can't read/duplicate Hidden formulas (I had to disable the Hidden attribute) (something like Range1.Formula = Range2.Formula doesn't work if Range2 is hidden) - Much more important: macros can't manipulate Shapes. I can't duplicate and delete shapes (I use many formcontrols, and I use macros to add and delete them) What can I do? I don't want to put the password of the sheet in the macro. (like Unprotect password:="topsecret") --- Bye |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
Macro error when worksheet is protected | Excel Discussion (Misc queries) | |||
Macro fails when worksheet protected | Excel Discussion (Misc queries) | |||
Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
How can I run a macro in a protected worksheet? | Excel Worksheet Functions |