View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] guillaume.trefeu@web.de is offline
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