hiden tabs & macros
 

Can you hide tabs and still run macros?

hiden tabs & macros
 

You can hide worksheets and still have a macro which accesses data on that
sheet, if that's what you mean. You can not hide all sheets, there must be
one visible, though if you create a userform, you could resize the visible
sheet to hide it behind the form.

If this doesn't answer your question, please explain your requirements
further.

--
Ian
--
"PG" wrote in message
...
Can you hide tabs and still run macros?

hiden tabs & macros
 

Yep (in the vast majority of cases).

Remember to not select the worksheet or a range on that sheet or any shape on
that sheet, though.

There are a few things that have to have the sheet selected to work--but I'd bet
you wouldn't be using them in a hidden sheet anyway.

If you're having trouble tweaking your code, post back with your specific
question.



PG wrote:

Can you hide tabs and still run macros?

--

Dave Peterson