Beatrix
05-26-2010, 09:23 AM
Dear All ,
I have a spreadsheet in Excel 2007. Some worksheets are hidden. Hide/Unhide options are greyed out. I tried to make them visible from VBA Project/Properties by changing the visible option to 1. However it gives an error message saying "Unable to set the Visible property of the Worksheet class" I've found out that workbook protection would cause this error. However the workbook is not protected. Visible tabs had a worksheet protection and I made them unprotected. Apart from that there isn't any password protection. I really don't know what the problem is:dunno, your help would be much appreciated..
Regards,
Yeliz
I have a spreadsheet in Excel 2007. Some worksheets are hidden. Hide/Unhide options are greyed out. I tried to make them visible from VBA Project/Properties by changing the visible option to 1. However it gives an error message saying "Unable to set the Visible property of the Worksheet class" I've found out that workbook protection would cause this error. However the workbook is not protected. Visible tabs had a worksheet protection and I made them unprotected. Apart from that there isn't any password protection. I really don't know what the problem is:dunno, your help would be much appreciated..
Regards,
Yeliz