Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB code to save worksheet as... | Excel Programming | |||
Save Excel Worksheet As CSV - No Save As Dialog | Excel Programming | |||
Problem: vba code for creating a button to save worksheet as Cell | Excel Programming | |||
When I tab in Excel, it jumps from column A to R. Why? | Excel Discussion (Misc queries) | |||
Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming |