hide non active sheets in workbook
 

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?

hide non active sheets in workbook
 

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?

hide non active sheets in workbook
 

On Oct 3, 7:03 pm, Tom Ogilvy
wrote:
If you ammend the code that unhides the sheet to hide any other sheet after
it unhides the one in question.

--
Regards,
Tom Ogilvy

Thankyou for this - logic if i'd applied my brain really!