Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I use code to lock multiple sheets.
I need to be able to allow the pasting/editing of objects in my protected sheets. Does anyone have the code to do this. For example I use AllowFormattingCells:=True and AllowFormattingRows:=True to enable other options in protected sheets. I find that AllowEditObjects:=True doesnt work. Can anyone help? Thanks, Roger |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sheet Protection / Edit Objects | Excel Worksheet Functions | |||
Sheet Protection / Edit Objects | Excel Worksheet Functions | |||
Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
Allow users to edit ranges for VBA objects | Excel Worksheet Functions | |||
I can't select/edit objects. It says [Group] on the header bar. | Excel Discussion (Misc queries) |