If you ammend the code that unhides the sheet to hide any other sheet after
it unhides the one in question.

--
Regards,
Tom Ogilvy


"anon" wrote:

Hi,

When a user opens the wb all sheets except one are hidden. There is a
custom menu bar with navigation buttons to the sheets. However a user
can theoretically open all of the sheets at once using these buttons.

I would like for each time a sheet is no longer the active sheet for
it to be hidden again automatically - is this possible?