hiding worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to a hide a worksheet that is referenced in one of my macros. Is
there a way to hide the worksheet without removing its availability to the
macro?

I am using Excel 2003.
 
It also depends on how your code references the worksheet. If you try to
select or activate a hidden sheet you'll get an error.

If you are referencing the sheet w/o selecting or activating it, you should
be okay.

If you hide the sheet and have problems, you can have the macro unhide the
sheet, then rehide it.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide columns based on row values 2
Close all without saving and exit without prompts 8
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Hide a worksheet 2
Hiding/Unhiding Rows Automatically 1
hyperlink not working in excel 2007, if worksheet is hide or hidden 4
Hiding worksheets 7
hide a worksheet so that a macro can still find it 1

Back
Top