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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable users to edit charts on a protected worksheet
On Jul 8, 9:48*pm, 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!! Can anyone please help me with my question??? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable users to edit charts on a protected worksheet
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 |
#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!! |
Reply |
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 |