Maximising rows and using macro buttons on a protected worksheet

Hi,

I'm trying to protect my spreadsheet but I having problems with the functionallity when doing so.

I want to be able to unhide about ten rows, by clicking the + on the left hand side. I also lose functionality when click the 'add floor' or 'remove floor' buttons if my sheet is protected.

I have inserted the following code:

Please Login or Register  to view this content.

My passowrd is sam....

Thanks

I think that should be

Please Login or Register  to view this content.

Hiya,

That ammendment didn't work Thalassa. It wont let me hide/unhide the rows and when I click the buttons I get a debug error box.

Does anyone know what can be done to solve this?

Thanks

Sam

Does anyone have any advice on this?

Please Login or Register  to view this content.

The above code doesnt let me hide/unhide rows or lets me click on macro buttons once the sheet is protected.

Thanks

Hi,

I still haven't got to the bottom of this protection lark. Can anybody help...

Please Login or Register  to view this content.

The above code doesnt let me hide/unhide rows or lets me click on macro buttons once the sheet is protected.

Thanks

Anybody? :-(