Global Macro

  • Thread starter Thread starter Bo Rasmussen
  • Start date Start date
B

Bo Rasmussen

Hi,

Using Excel '97.

How do I create a set of Global Excel macros? In MS word I simply put a .dot
file in the microsoft office/office/STARTUP folder, and the macros are
automatically available. How is that done for Excel? I''ve tried to put both
..xlt and .xls files in the STARTUP folder, but nothing appears

Thanks
-Bo
 
Hi Bob,

As far as I understand personal.xls should be opened in some kind of
invisible mode. On my excel '97 system personal.xls is opened just like any
'normal' xls file upon starting Excel. That is - it is visible and ready for
editing.
I doesn't really help me a lot - but thanks anyway.

-Bo
 
Make personal.xls the active window (so you can see it).

Then window|Hide

Now close excel and answer yes to the "do you wanna save personal.xls" prompt?

Next time you open excel, personal.xls will open hidden.
 
Hi Dave

Thanks :o)

Regards
Bo Rasmussen
Dave Peterson said:
Make personal.xls the active window (so you can see it).

Then window|Hide

Now close excel and answer yes to the "do you wanna save personal.xls" prompt?

Next time you open excel, personal.xls will open hidden.
Click to expand...
 
Back
Top