ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Invisible sheets (https://www.excelbanter.com/excel-worksheet-functions/188141-invisible-sheets.html)

emilh

Invisible sheets
 
Hi.

I have received an excel file with vba and it has the code which prevents
the file to display most sheets. Is there any way (user level) other than
deleting or commenting that section of code to display the sheets?

Thank you.
--
Emil

Roger Govier[_3_]

Invisible sheets
 
Hi

If the file has not been protected, and if the sheets are not set to
VeryHidden, then FormatSheetsselect sheetUnhide

--
Regards
Roger Govier

"emilh" wrote in message
...
Hi.

I have received an excel file with vba and it has the code which prevents
the file to display most sheets. Is there any way (user level) other than
deleting or commenting that section of code to display the sheets?

Thank you.
--
Emil



ryguy7272

Invisible sheets
 
If the file is password protected you can't access very hidden sheets. You
can break the password with some tools available on the web.
http://mcgimpsey.com/excel/removepwords.html

http://lastbit.com/vba/

http://wareseeker.com/Business-Finan...0.3.zip/317723

There are many other resources available via a simple Google search. I'll
leave it to you to find them...

Regards,
Ryan---

--
RyGuy


"Roger Govier" wrote:

Hi

If the file has not been protected, and if the sheets are not set to
VeryHidden, then FormatSheetsselect sheetUnhide

--
Regards
Roger Govier

"emilh" wrote in message
...
Hi.

I have received an excel file with vba and it has the code which prevents
the file to display most sheets. Is there any way (user level) other than
deleting or commenting that section of code to display the sheets?

Thank you.
--
Emil




All times are GMT +1. The time now is 09:33 PM.

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