#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,480
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
invisible color cindyhosch Excel Worksheet Functions 4 April 14th 10 04:53 PM
Invisible sheets emilh Excel Discussion (Misc queries) 2 May 20th 08 10:53 AM
Invisible Formatting ? or ... ? Steve Excel Worksheet Functions 6 May 8th 08 06:24 PM
Invisible Workbook rwt_ray Excel Discussion (Misc queries) 0 December 5th 06 06:21 PM
Invisible bar on bar chart KK New Users to Excel 3 November 24th 06 01:22 PM


All times are GMT +1. The time now is 12:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"