Look in the ThisWorkbook code module for a procedure named
Workbook_BeforeSave. There, comment out the code that is causing the
jump to Sheet7.
Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
The San Diego Project Group, LLC
(email is on the web site)
USA Central Daylight Time (-5:00 GMT)
On Thu, 9 Oct 2008 13:47:02 -0700, BillJenk
wrote:
I have a multi sheet excel workbook that has VBA coding. When I go to save
the workbook it jumps to Page 7(Sheet7) and starts running the activate code
for page 7. How can I stop it from jumping to page7 on save.