Thread: Global Macro

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

Add them to the personal.xls file.

--
HTH

Bob Phillips

"Bo Rasmussen" <krogenlund@hotmail.com> wrote in message
news:egJZcB5tFHA.996@TK2MSFTNGP10.phx.gbl...
> 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

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:OP9UiP5tFHA.2008@TK2MSFTNGP10.phx.gbl...
> Add them to the personal.xls file.
>
> --
> HTH
>
> Bob Phillips
>
> "Bo Rasmussen" <krogenlund@hotmail.com> wrote in message
> news:egJZcB5tFHA.996@TK2MSFTNGP10.phx.gbl...
> > 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
> >
> >
>
>

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.

Bo Rasmussen wrote:
>
> 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
>
> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:OP9UiP5tFHA.2008@TK2MSFTNGP10.phx.gbl...
> > Add them to the personal.xls file.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "Bo Rasmussen" <krogenlund@hotmail.com> wrote in message
> > news:egJZcB5tFHA.996@TK2MSFTNGP10.phx.gbl...
> > > 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
> > >
> > >
> >
> >

--

Dave Peterson

Hi Dave

Thanks :o)

Regards
Bo Rasmussen
"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:43259046.453ABA64@verizonXSPAM.net...
> 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.
>
> Bo Rasmussen wrote:
> >
> > 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
> >
> > "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> > news:OP9UiP5tFHA.2008@TK2MSFTNGP10.phx.gbl...
> > > Add them to the personal.xls file.
> > >
> > > --
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > "Bo Rasmussen" <krogenlund@hotmail.com> wrote in message
> > > news:egJZcB5tFHA.996@TK2MSFTNGP10.phx.gbl...
> > > > 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
> > > >
> > > >
> > >
> > >
>
> --
>
> Dave Peterson