PDA

View Full Version : Unable to set the Visible property of the Worksheet class



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

Paul_Hossler
05-26-2010, 01:11 PM
Try -1

Paul

Beatrix
05-27-2010, 02:23 AM
Hi Paul ..

Thanks for your respond. Visible options are -1/0/2. I've already tried -1, (sorry it was my mistake, I should have said -1 instead of 1). It doesn't let me change the option from 0 to -1 and the error message pops up saying Unable to set the Visible property of the Worksheet class..:(

xld
05-27-2010, 03:04 AM
Post the workbook.