hiden tabs & macros

[Guest]

Can you hide tabs and still run macros?

 

[Ian]

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.

 

[Dave Peterson]

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.