Hey Guys,
See, there are bunch of Sheet
example: Sheet1, Sheet2, Sheet3
No matter where i save it and Close, When i open the Excel again i want excel to start with "Sheet1" Itself
example: If i save the Excel at Sheet2 and Close it, and when i reopen the excel it should show the Sheet1.
Is there a way to Do this.
PLZ Help.............
Use the Workbook_BeforeClose event
Private Sub Workbook_BeforeClose(Cancel As Boolean) Sheet1.Select ThisWorkbook.Close True End Sub
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks