Bern,

Q1. You could use an event, and tie your code to that. For example, the
workbook open event could check the day of the week and you could use logic
to decide which sheets to show and which to hide. Specifically what event
and how to use it requires a bit more explanation of what you want on your
part.

Q2. Yes, you could use the worksheet activate event to change the visible
property of the 'linked' sheets. But the code, again, depends on what you
mean by linked.

HTH,
Bernie
MS Excel MVP


"Bern Notice" wrote in message
...
Q1: Can a file be setup so a macro is always running?

I wrote a macro that allows a user to pick a day of the week with a text
box
and based on that selection "groups" of worksheets linked to the selected
day
are shown and the other sheets are hidden (that way a user can look at
worksheets only "linked" to a particular day of the week).

Q2: Is there a way to be able to just click on a worksheet tab and have a
set of worksheets that are "linked" to that tab automatically shown (they
would be hidden otherwise)?