Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable users to edit charts on a protected worksheet
Hi,
I have a worksheet where I need to protect from users editing the content. However, I would like the user to format the excel charts within the workheet, i.e. they can copy the charts, change the sizes and also re-format. I have used this VB code to protect my worksheets in the past. Is there a way of amending this code to also enable the users to edit charts? Sheet1.Protect Password:="password", DrawingObjects:=True, _ contents:=True, Scenarios:=True, _ userinterfaceonly:=True Sheet1.EnableAutoFilter = True Sheet1.EnableOutlining = True Thanks for your help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
How do I allow users to edit links in a protected worksheet? | Excel Worksheet Functions | |||
Enable outlining in a protected worksheet | Excel Discussion (Misc queries) | |||
How do I enable the spellchecker in a protected worksheet? | Excel Programming | |||
Enable grouping in protected worksheet | Excel Programming |