Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allow Edit Objects in protected sheets
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allow Edit Objects in protected sheets
The macro recorder is your friend
ActiveSheet.Protect DrawingObjects:=False Gord Dibben MS Excel MVP On Mon, 4 Aug 2008 17:40:00 -0700, Roger on Excel wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allow Edit Objects in protected sheets
Thanks again Gord,
By the way i tried to make pivot table active by using the recorder to generate code for me, but it doesnt seem to work. Do you have any advice on getting pivot tables to work on protected sheets using code? Best regards, Roger "Gord Dibben" wrote: The macro recorder is your friend ActiveSheet.Protect DrawingObjects:=False Gord Dibben MS Excel MVP On Mon, 4 Aug 2008 17:40:00 -0700, Roger on Excel wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |