Unable to set the visible property of the worksheet class

[kkyuvaraj]

Hi,

I have an excel sheet, where a worksheet is xlveryhidden and if I try to make it visible it is showing an error "Unable to set the visible property of the worksheet class".

I am not sure that the hidden excel sheet is password protected or not.

Can anybody help with this to make the sheet visible?

Have uploaded the error page FYR.

 

[Fluff]

Is the workbook protected?

 

[kkyuvaraj]

Is the workbook protected?

No

 

[Fluff]

Are you trying to unhide the sheet manually?

 

[kkyuvaraj]

Are you trying to unhide the sheet manually?

I am trying to unhide through VBA properties

 

[Fluff]

Are you doing it manually or with code?

 

[kkyuvaraj]

Are you doing it manually or with code?

Manually

 

[kkyuvaraj]

Manually

For better understanding I hereby provided the excel sheet link.

Google Drive: Sign-in

Access Google Drive with a Google account (for personal use) or Google Workspace account (for business use).

drive.google.com

 

[Fluff]

That link is asking me to sign in. You need to mark the file for sharing & then post the link you are given.