------ Register to get rid of these "In Post" ads! ------


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.
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/excel-vba-programming/2268-save-excel-jumps-another-worksheet-how-fix-visual-basic-applications-code.html#post6592

------ Register to get rid of these "In Post" ads! ------


It's hard to tell. What does your Workbook_Before save event look like?
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/excel-vba-programming/2268-save-excel-jumps-another-worksheet-how-fix-visual-basic-applications-code.html#post6601
--
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.

------ Register to get rid of these "In Post" ads! ------


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
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/excel-vba-programming/2268-save-excel-jumps-another-worksheet-how-fix-visual-basic-applications-code.html#post6602
(email is on the web site)
USA Central Daylight Time (-5:00 GMT)



On Thu, 9 Oct 2008 13:47:02 -0700, BillJenk
<BillJenk@discussions.microsoft.com> 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.