ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VerilyHiddenSheet-VBA Editor (https://www.excelbanter.com/excel-programming/326935-verilyhiddensheet-vba-editor.html)

gr8guy

VerilyHiddenSheet-VBA Editor
 
Hi,

I dont know what setting has changed in Excel 2002 XP, now whenever i try to
use VBA Editor & make a sheet which was verylyhidden by code by me, it gives
me a message & does not make the sheet visible.

"Unable to set Visible property of the WorkSheet class"

Any help would be most appreciated.

Rgds,

Eijaz




anonymousA

VerilyHiddenSheet-VBA Editor
 
Hi,

Did you unprotect your workbook before running this code ?

Regards

gr8guy a écrit :
Hi,

I dont know what setting has changed in Excel 2002 XP, now whenever i try to
use VBA Editor & make a sheet which was verylyhidden by code by me, it gives
me a message & does not make the sheet visible.

"Unable to set Visible property of the WorkSheet class"

Any help would be most appreciated.

Rgds,

Eijaz





All times are GMT +1. The time now is 10:05 PM.

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