My worksheet starts showing only command button (and certain rows). I am hoping to show those hidden rows only when the user click the button. Here's the code:
Please Login or Register  to view this content.
Problem is, unhide can easily be done just highlighting the hidden rows. Yet, if I protect it using the Excel Menu and include "Format Rows" option, I get the "Unable to set the property of the Hidden Class" error. Since I'm in a shared environment, I can't use the protect/unprotect sheet. Any help?

Thanks.