Morning all ..
I have two macro buttons on a page that hide and unhide columns.
When I got to protect the sheet .. the buttons no longer work and ask me to DEBUG.
Is there a way to have macro buttons performing tasks AND have the sheet still protected?
In the protect sheet window .. am I have ticked is
Select Locked Cells
Select Unlocked Cells
But these are ticked as a default.
Anyone help out?