LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default What's this new sheet?


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel sheet bootom half sheet goes behind top part of sheet rob Excel Worksheet Functions 2 January 17th 09 01:28 AM
Duplicate sheet, autonumber sheet, record data on another sheet des-sa[_2_] Excel Worksheet Functions 0 May 8th 08 06:56 PM
How do I select price from sheet.b where sheet.a part no = sheet.b Sonny Excel Worksheet Functions 4 April 4th 06 05:08 PM
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. RonMc5 Excel Discussion (Misc queries) 9 February 3rd 05 12:51 AM
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 Hannes Heckner Excel Programming 1 March 5th 04 09:10 AM


All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"