calculate remains in status bar
 

Hi,

Environment: XL2002, WIN XP

Action: Copy some sheets from a source book into a new book,
for distribution purpose (with VBA or manually, it doesn't matter)

Problem: After the procedure is done, the "Calculate" remains in statusbar,
even when I close the source book and the copy book and no book is active.

What's the reason for that behaviour?

Thanks for your support.
Werner

calculate remains in status bar
 

Check Tools | Options... | Calculation tab. Either Calculation mode is
Manual or Iteration is enabled.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , werner-
says...
Hi,

Environment: XL2002, WIN XP

Action: Copy some sheets from a source book into a new book,
for distribution purpose (with VBA or manually, it doesn't matter)

Problem: After the procedure is done, the "Calculate" remains in statusbar,
even when I close the source book and the copy book and no book is active.

What's the reason for that behaviour?

Thanks for your support.
Werner

calculate remains in status bar
 

http://support.microsoft.com/?kbid=243495
The Calculate message may remain in the status bar when you enter formulas
that include cell references


--
Regards,
Tom Ogilvy


"Werner Rohrmoser" wrote in message
...
Hi,

Environment: XL2002, WIN XP

Action: Copy some sheets from a source book into a new book,
for distribution purpose (with VBA or manually, it doesn't matter)

Problem: After the procedure is done, the "Calculate" remains in
statusbar,
even when I close the source book and the copy book and no book is active.

What's the reason for that behaviour?

Thanks for your support.
Werner

calculate remains in status bar