Macros available everytime

R

RogueIT

Is there a way I can make a macro available for every excel sheet I open?

thanks,
RogueIT
 
P

Peo Sjoblom

If you store the macros in your personal.xls they will be available, to
create a personal.xls just record a macro and select personal macro
workbook, then delete what you recorded and replace with all the other
macros (alt + F11 opens the VBE)


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
Z

Zack Barresse

Hello there RogueIT,

Yes there is! You need a Personal.xls file. This does not come with a
default installation of Excel, you must create it. This is a global file
that is stored in your XLSTART folder; it is always hidden by default.

If you do not have one the easiest way to create one (IMHO):
Tools | Macro | Record new macro
Store macro in: Personal Macro Workbook | Ok
Click the Stop Recording button

Now you have it! Excel will automatically create it and save it in the
correct/default folder for you. Then to install macros in your Personal.xls
(if you are not recording them there) hit Alt + F11. This will bring up
your VBE. Press Ctrl + R to show the Project Explorer (if it's not already
showing) and find Personal.xls in bold in your PE. Expand it and you should
see a Modules folder. This is where your standard modules are stored and
where the recorded macros go. All procedures stored in any module there
(with regards to any being set to Private) when in Excel (Alt + Q will
return to Excel from your VBE) if you press Alt + F8 you will see your macro
list (Tools | Macro | Macros) and they will be available to run there.

HTH
 
P

Patricia Shannon

I am working on an application that is on a network drive, and is available
to others. To make the macros available to anybody who need them, I have put
them all on a single file. I have a custom toolbar with buttons for most of
the macros, and when I press one, it automatically opens my macro worksheet.
 
Top