LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Macro needs data from hidden worksheet

Hello,

I am developing an Excel-Sheet in order to compare easily vehicle
dimensions.

I have written a few macros that need to access data from a worksheet
called "Cache".
To avoid any future damage caused by "inexperienced" users, I want
to hide this worksheet "Cache" (Format - Worksheet - Hide). But
in this case the macro cannot work!!!

The macro needs to "see" the worksheet!

Is there any way I can hide the worksheet "Cache" and run the macro
at the same time.

Again, I would really appreciate any help. Thanks a lot!

Guillaume

 
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
Macro running against hidden worksheet George Excel Discussion (Misc queries) 1 July 23rd 07 09:42 PM
How do I detect hidden worksheets or hidden data on a worksheet? Alice Excel Discussion (Misc queries) 4 August 24th 06 03:38 AM
find hidden data in worksheet catlover1946 Excel Worksheet Functions 19 July 20th 06 03:33 AM
macro to hidden worksheet murph306 Excel Discussion (Misc queries) 8 June 1st 06 02:35 PM
Saving hidden data with a worksheet (preferably without using a hidden sheet) Dick Kusleika[_3_] Excel Programming 2 January 21st 04 04:39 PM


All times are GMT +1. The time now is 04:53 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"