Difference between Word and Excel
VBE closes down in both cases for me. I don't use the VBE much in Word, but
I never remember it staying open in 97, 2000 or 2002 when I have closed
word on many different computers.
--
Regards,
Tom Ogilvy
"Hari Prasadh" wrote in message
...
Hi Tom,
Im sorry, not able to understand you.
I followed this procedu
a) Excel - Open a new session by typing Excel in run. Then I press Alt +
F11
when Excel normal windows opens up. I go back to excel normal window and
click on the close button. VBE also closes down.
b) Word - Open a new session by typing Winword in run. Then I press Alt +
F11 when Word normal windows opens up. I go back to Word normal window and
click on the close button. VBE remains open.
(It could be possible that I might have some setting differences between
the
2 programs which may be causing the above difference in behaviour.)
Thanks a lot,
Hari
India
"Tom Ogilvy" wrote in message
...
In excel if I have VBE open
and if i close all the excel normal windows then VBE will also close
down.
I can't reproduce that behavior. (unless you mean close Excel and in
word
the VBE closes as well when I close word).
--
Regards,
Tom Ogilvy
"Hari Prasadh" wrote in message
...
Hi,
I posted this question in the word group 2 days back but......
Just curious about the differences in the common features of Word and
Excel.
Here I go.
Why is word VBE a little different to Excel VBE? In excel if I have VBE
open
and if i close all the excel normal windows then VBE will also close
down.
But in Word If I have VBE open and close all the documents, VBE still
remains open. Is this difference somehow related to the products being
different (number crunching vs word processing). If so what exactly is
there
within Word processing that MS has made VBE available even when Word
document is not open.
Why is it that Undo stack empties out on pressing save while in word it
is
still available.
Thanks a lot,
Hari
India
|