Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
frendabrenda1
 
Posts: n/a
Default hide a worksheet so that a macro can still find it

Good morning.

I am trying to hide worksheets (preferably very hidden) that my macro must
find. Every time I hide the sheets the macro quits working because it can't
find the sheet. Is there a way to hide the sheets frmo a user, but allow the
Macro to find it?
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi frendabrenda1

You can't select cells on a hidden sheet or activate/select it
but you can change values without selectiing.

For example this will work if the sheet is hidden or not
Sheets("Sheet1").Range("A1:D5").Value = "ron"


--
Regards Ron de Bruin
http://www.rondebruin.nl


"frendabrenda1" wrote in message
...
Good morning.

I am trying to hide worksheets (preferably very hidden) that my macro must
find. Every time I hide the sheets the macro quits working because it can't
find the sheet. Is there a way to hide the sheets frmo a user, but allow the
Macro to find it?



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
Hide AutoShapes On Excel Worksheet Dave Y Excel Worksheet Functions 5 June 12th 05 04:26 AM
Cannat paste that macro formula onto a worksheet Stephen White Excel Discussion (Misc queries) 2 May 27th 05 11:58 AM
how to find and replace a symbol in my worksheet TC Excel Discussion (Misc queries) 3 May 3rd 05 06:29 PM
Making Find go through worksheet only once Frank Marousek Excel Discussion (Misc queries) 3 April 27th 05 07:40 PM
How do I find a Macro in Excel when I don't know its name? LLEECEE Excel Discussion (Misc queries) 2 March 31st 05 10:28 PM


All times are GMT +1. The time now is 08:31 PM.

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

About Us

"It's about Microsoft Excel"