LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default How do I detect hidden worksheets or hidden data on a workshee

Thanks for your help. There were in fact empty objects on the worksheet.

Alice

"Dave Peterson" wrote:

Do you have any pictures/shapes on the worksheet?
Edit|Goto|special|check objects

Open your workbook
hit alt-f11 to get to the VBE
hit ctrl-r to see the project explorer (like windows explorer)
Select your project in that window
hit the asterisk on the numeric keypad to expand everything.

Do you see more than one sheet under Microsoft Objects?

You should see all the sheets and ThisWorkbook.

Debra Dalgleish has some screen prints (for a different purpose), but you may
want to refer to them if you have trouble:

http://www.contextures.com/xlfaqMac.html#NoMacros



Alice wrote:

I have a workbook with one worksheet which appears to be empty, however the
saved file is 3.5Mb. I am at a loss as to where all that content is?


--

Dave Peterson



 
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
Retrieve data from all of the worksheet within the file dannyboy213 Excel Worksheet Functions 1 March 22nd 06 06:51 PM
ranking query JaimeTimbrell Excel Discussion (Misc queries) 2 February 16th 06 08:09 AM
Inserting a new line when external data changes Rental Man Excel Discussion (Misc queries) 0 January 11th 06 07:05 PM
Sharing data across worksheets within a workbook based on identifi deedle93 Excel Discussion (Misc queries) 2 August 18th 05 04:26 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


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

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"