On save excel jumps to another worksheet. How to fix VBA code?
 

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.

On save excel jumps to another worksheet. How to fix VBA code?
 

It's hard to tell. What does your Workbook_Before save event look like?
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"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.

On save excel jumps to another worksheet. How to fix VBA code?
 

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.