![]() |
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 |
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 |
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