Placing XL macros in PERSONAL.XLS

[davegb]

I'm just learning again how to create macros. I find that XL, by
default, creates new macros in the current workbook. Then, if I want to
be able to use them in other workbooks, I have to open the workbook I
created them in, or move them to PERSONAL.XLS. Do I have to unhide
PERSONAL.XLS and create the macro from there everytime I create a
universal macro?
TIA

 

[JulieD]

Hi Dave

if you use alt & F11 to switch the the VBE editor - you will see
Personal.xls listed - which means you don't have to unhide/hide it to access
it. Just copy & paste with the VBE window.

Cheers
JulieD

 

[Gord Dibben]

dave

Also, if recording a macro, you will be given the choice of where to store the
macro when you hit "Record New Macro".

This workbook or Personal Macro Workbook are two of the options.


Gord Dibben Excel MVP

 

[davegb]

if you use alt & F11 to switch the the VBE editor - you will see
Personal.xls listed - which means you don't have to unhide/hide it to
access
it. Just copy & paste with the VBE window.


Thanks, Julie! that helps.
Also, if recording a macro, you will be given the choice of where to
store the
macro when you hit "Record New Macro".


This workbook or Personal Macro Workbook are two of the options.


Gord Dibben Excel MVP

Knew about that one, Gord. But isn't it strange that when you create a
macro, it doesn't give you an option of where to put it?
Knew about that one,