Enable users to edit charts on a protected worksheet

R

roniaelm

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!!
 
R

roniaelm

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???
 
D

Dave Peterson

I didn't test this, but it won't take too long for you to try protecting the
worksheet with DrawingObjects:=false.
 
R

roniaelm

I didn't test this, but it won't take too long for you to try protecting the
worksheet with DrawingObjects:=false.











--

Dave Peterson- Hide quoted text -

- Show quoted text -

Thanks for replying!
That worked!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top