Need macros in file to be available, but don't want file to open

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tomfabtastic@hotmail.com - 27 Nov 2007 23:40 GMT

Hello,

I have an excel file holding a number of macros that I would like to
be able to access whenever excel is open. I have saved this file at C:
\Program Files\Microsoft Office\OFFICE11\xlstart. Now, when I open
excel, this file opens. However, I don't want the file to open, I just
want the macros in the file to be available.

Thanks,
Tom

Reply to this Message

carlo - 28 Nov 2007 00:20 GMT

What you are looking for is an add-in.

open your file, go to "save as..." and
choose .xla as file format. excel should
change the destination by itself and you
can save it directly there. close the
whole excel, open a new blank one and
go to "Tools" --> "add-ins" and you should
see your file in the list.

there are some better tutorials out there:
http://www.ozgrid.com/VBA/excel-add-in-create.htm

hth

Carlo

On Nov 28, 8:40 am, tomfabtas...@hotmail.com wrote:

> Hello,
>
[quoted text clipped - 6 lines]
> Thanks,
> Tom

Reply to this Message

sebastienm - 28 Nov 2007 00:40 GMT

Hi,
If you mean that what is bothering you is that you can see the file as a
regular xl book when xl opens, then you can actually set the IsAddin property
to True in the Properties window (vba editor). From now on, when excel opens,
it still opens the file from xlStart but the file is not displayed anymore
(only accessible in the vba editor).

Signature

Regards,
Sébastien
<http://www.ondemandanalysis.com>

> Hello,
>
[quoted text clipped - 6 lines]
> Thanks,
> Tom

Reply to this Message

Gord Dibben - 28 Nov 2007 00:45 GMT

Hide the file and save it so's it opens hidden.

Your macros will still be available.

Gord Dibben MS Excel MVP

>Hello,
>
[quoted text clipped - 6 lines]
>Thanks,
>Tom

Reply to this Message

tomfabtastic@hotmail.com - 28 Nov 2007 04:49 GMT

> Hide the file and save it so's it opens hidden.
>
[quoted text clipped - 14 lines]
>
> - Show quoted text -

Fantastic - thanks, add-in works well.

Reply to this Message