hide non active sheets in workbook

  • Thread starter Thread starter anon
  • Start date Start date
A

anon

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?
 
If you ammend the code that unhides the sheet to hide any other sheet after
it unhides the one in question.
 
If you ammend the code that unhides the sheet to hide any other sheet after
it unhides the one in question.
Click to expand...
Thankyou for this - logic if i'd applied my brain really!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error Message - Macro to Unlink MS Queries from Workbook 0
Desplay active and Hide sheets 1
HIDE / UNHIDE sheets based on user answers 5
Autohide rows based on formula in another sheet 0
copy text and logo from protected, hidden sheet 1
Sheet activate question 4
unhiding / hiding sheets 5
Keep lot of sheets Displayed and Hide Other 2

Back
Top