Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet containing 7 sheets and lots of code, running in
Excel 97 SR1 with the AutoSave addin enabled. When working in a sheet, when AutoSave runs, the leftmost worksheet in the tab order is activated. I've traced this to the following code in my WorkBook Open macro: Windows(1).Caption = (ActiveWorkbook.FullName) This puts the path in the titlebar. If I close Excel, then create a new blank workbook and run this code in the immediate window, then open sheet 3 and type the letter a in A1, when AutoSave runs, it activates sheet 1. I added the AutoSave addin to Excel 2003 and have the same problem with it. Anyone have any thoughts on why AutoSave does this? I haven't had time to try to get past the project password in AutoSave.xla so I can't look at the code. Thanks. Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with Autosave | Excel Discussion (Misc queries) | |||
Opened Autosave but when closing workbook Autosave closes itself | Excel Worksheet Functions | |||
Removing AUTOSAVE.XLS(AUTOSAVE.XLA) from VBA editor??? | Excel Programming | |||
Removing AUTOSAVE.XLS(AUTOSAVE.XLA) from VBA editor??? | Excel Programming | |||
problem with this code | Excel Programming |