Display sheet upon exit

  • Thread starter Thread starter JAMES SYLVESTERSR
  • Start date Start date
J

JAMES SYLVESTERSR

Is there a way in VBA to cause a worksheet to display when exiting the
workbook.
 
Is there a way in VBA to cause a worksheet to display
when exiting the workbook.
Click to expand...

Yes, put code like this in the ThisWorkbook module.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets("fill_name").Activate
End Sub


HTH,
Merjet
 
James,

It could be done with the Workbook_Deactivate event , but ..
Wouldn't this mean that you could never switch to another workbook, as by
making a worksheet in that workbook visible, you re-enter it?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
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

VBA Error Handling 4
[Q] How to sort tabs in order of CodeName 2
How to hide password? 1
Excel Providing user message when RED X clicked & properly closing application. 2
enter key behavior - by sheet 4
Data Validation List problem 5
excel 2003 vs 2007 menu and sheet issues 3
Combine three InputBoxes into one? 7

Back
Top