| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable users to edit charts on a protected worksheet
On Jul 10, 9:39*pm, Dave Peterson wrote:
I didn't test this, but it won't take too long for you to try protecting the worksheet with DrawingObjects:=false. wrote: 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!! -- Dave Peterson- Hide quoted text - - Show quoted text - Thanks for replying! That worked!! |
| 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 | |||
Threaded Mode
