ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problems Unhiding a Worksheet (https://www.excelbanter.com/excel-programming/323714-problems-unhiding-worksheet.html)

[email protected]

Problems Unhiding a Worksheet
 
Hi -

I have a file with hidden sheets that I can not unhide. There are no
passwords that I am aware of. The unhide function under Format
Sheets is not available. In VBA, the sheet is set to "-1 - xlsheet
visible". When I try to change it, I receive an error, "Unable to set
the Visible property of the Worksheet class.". Any ideas?

Stephen


anonymousA

Problems Unhiding a Worksheet
 
Hi,

if you tried to unprotect the workbook, would it help you ?

So long

a écrit :
Hi -

I have a file with hidden sheets that I can not unhide. There are no
passwords that I am aware of. The unhide function under Format
Sheets is not available. In VBA, the sheet is set to "-1 - xlsheet
visible". When I try to change it, I receive an error, "Unable to set
the Visible property of the Worksheet class.". Any ideas?

Stephen



All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com