Runtime Error using Command Button when Worksheet is Protected

[HangMan]

I have a worksheet containing a 'Toggle Button'. The toggle button is used to show and hide grouped columns and functions perfectly correctly, however, as soon as I protect the worksheet, clicking the toggle button generates a 'Run-time error '1004' - Unable to set the hidden property of the range class'.

This is the code I am using to show and hide the columns.

Please Login or Register  to view this content.

What do I need to add to this code to prevent this problem from occuring, when the sheet is protected?

Many thanks

[JBeaucaire]

Please Login or Register  to view this content.

[HangMan]

Hi JBeaucaire,

That works perfectly, though I've realised that when the sheet is protect, I am unable to update a graph that also appears on the sheet!

Is there an additional line of code that needs to be added to the Toggle Button, to allow the graph to update when data is changed via a ComboBox? Or do I need to change something specific to the graph itself?

I tried adding Activesheet.ProtectData = False, to the Toggle Button code, but this doesn't work. I've also tried unchecking 'Locked' from the ComboBox Protection from the ComboBox Properties, so I'm unsure what I need to do to allow the graph to keep updating as the source data changes via selections made from the ComboBox. I get this error, when selecting an item from the ComboBox to update the chart, when the worksheet is protected:

protect.jpg

Please Login or Register  to view this content.

Many thanks...