How Can I hide sheets when closing the app?

  • Thread starter Thread starter jose luis
  • Start date Start date
J

jose luis

Hello, Community...


I have an WorkBook with 5 sheets and i want to hide 4 of them when th
user closes the WB, so the next time she opens the WB just the firs
sheet is available and visible.

I think that this task can be done with some instruction like "O
Close" or something. Any idea on how to acomplish this?


Thanks, a lot.

Jose Lui
 
Thanks...

I realize the section in this forum "Events in VBA" and found th
solution to my problem. What a wonderfull world!!.


Thanks to all the community again.

jose lui
 
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

Hide Sheets when closing file 2
Excel 2007 Craches when closing via macro code 3
2003 created Workbook casuses error when macro runs in 2007 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
filename problem in VB 1
Hide Sheet using Workbook Open Event 4
App_WorkbookBeforeClose 1
HIDE / UNHIDE sheets based on user answers 5

Back
Top