Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have a large suite of workbooks with multiple sheets and macros, basically all working, but..... Some of the macros take a long time, and involve loops etc. I have arranged for most of my macros to write to the Status bar to keep me informed of progress. This was written in XL2000, and worked just fine. Now I've upgraded to XL2003, and whilst the macros works, some strange new things are happening! At some point during execution - and it's not always the same point - a new sheet appears minimized on the taskbar. The icon on the active window (at the top left of the window) changes to a plain white recangle, and the status bar stops updating. When execution concludes the new window closes, the proper XL icon returns, and the status bar clears (as it should because I've written that into my macro). If I hover the mouse over the new window on the task bar, the tooltip tells me that it has the same name as one of the other already-open workbooks. Dependent on which of my macros is running and/or which of my books is the active book, different duplicate books are opened. What's going on? And how might I stop it? -- Adrian D.Bailey, Information and Systems Manager, Dept.Human Sciences Loughborough University, Loughborough Leics, LE11 3TU, UK. Tel: 01509 223007 Fax: 01509 223940 Community Warden, Storer and Burleigh Areas. Out-of-hours Tel: 01509 563263 -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |