Where do macros go?

[Yellowbird]

Hi all,

I've learned a lot from various folks here and really appreciate all
suggestions/tips. I have a macro that works properly and was saved as
part of the personal.xls workbook. I now want to remove it from there,
but cannot determine how to delete the personal.xls file on a machine
running WinXP. There is no XLSTART folder, although that's where I
think the personal.xls file would be. I installed a macro in
personal.xls on several machines and it must have been available (not
hidden) or the users unhid it, because now personal.xls pops up every
time a new worksheet is created. We want book1.xls to be the default,
with the macro that is stored within personal.xls available to be run.

Second question is, where is the best place to put macros on an
individual user's machine? Is personal.xls the best place? Others have
suggested including a macro as an add-in, but all I really want is a
list of available macros when I create a new worksheet. So,
technically, I guess I do have a global macro, which should go in the
personal.xls worksheet, right?

Any clarification is greatly appreciated.

Thanks.
Yellowbird

 

[Don Guillett]

Please forgive me. I just couldn't resist. Reminds me of a song.
With your ng name, you should appreciate it. That's another folk song.

Well, I got to thinking the other day, when I saw a macro float away
I saw a macro float into the sky
I've seen macros fly above the clouds but I've seen one come down again.
where do macros go when they die?

Is there a heaven for macros, my friend
Is there a place to which they go
Or do they simply fade away into the sky
I think that I shall never know

A aeroplane must land somewhere and a rocket throw must fall
a bird must come to rest as we have learned
but when a macro begins to rise, trailing it's little thing behind
have you ever known it to return

Is there a heaven for macros, my friend
Is there a place to which they go
Or do they simply fade away into the sky
I think that I shall never know

Colors gleaming in the sun, dancing with each passing breeze
rising thru the air into the sky. Drifting from the soft embrace
a gentle cloud & breeze below, so like a spirit does it lie.

Is there a heaven for macros, my friend
Is there a place to which they go
Or do they simply fade away into the sky
I think that I shall never know
========
(Heaven for balloons)

Do a WINDOWS find for personal.xls whose location depends on your version.
If desired, you don't have to delete the whole file, just remove the module
the macro was in.

 

[Gord Dibben]

Bird

You will have an XLSTART folder on your Computer.

Do a file/folder search on your computer.

Make sure your search parameters include "hidden files and folders".

Also you can open My Computer and Tools>Folder Options>View>Files and Folders
and set options to show all files and known extensions.

Personal.xls is created the first time you record a Macro using Macro
Recorder.

Tools>Macro>Record New Macro. A dialog box will come up asking you name the
macro and where to place it. Pick Personal Macro Workbook from the dropdown.
Copy and paste a couple of cells then Stop Recording.

You now have a Personal.xls in your Office\XLSTART folder. You can go to
Visual Basic Editor(Alt+F11) to view the macro you just recorded in a Module.

You can add more macros by recording or by typing them into the Module.

You can do a File>Save from there or when you close Excel you will be asked if
you want to save Personal.xls. Yes!

If it opens in a visible state go to Window>Hide and again save it.

As far as distribution of macros to other users goes........

It is not a good idea to overwrite other users' personal.xls with a copy of
your own.

The add-in method makes for easier updating of your macros.

Send the add-in to users and they can load it through Tools>Add-ins.

True...you will not see the macros listed in Tools>Macro>Macros if you use an
Add-in.

Gord Dibben Excel MVP

 

[bbc1]

If you want book1.xls to be default, open excel and when
personal.xls opens select to hide workbook and save, next
time you open excel it will open in book1

-----Original Message-----
Bird

You will have an XLSTART folder on your Computer.

Do a file/folder search on your computer.

Make sure your search parameters include "hidden files and folders".

Also you can open My Computer and Tools>Folder Options>View>Files and Folders
and set options to show all files and known extensions.

Personal.xls is created the first time you record a Macro using Macro
Recorder.

Tools>Macro>Record New Macro. A dialog box will come up asking you name the
macro and where to place it. Pick Personal Macro Workbook from the dropdown.
Copy and paste a couple of cells then Stop Recording.

You now have a Personal.xls in your Office\XLSTART folder. You can go to
Visual Basic Editor(Alt+F11) to view the macro you just recorded in a Module.

You can add more macros by recording or by typing them into the Module.

You can do a File>Save from there or when you close Excel you will be asked if
you want to save Personal.xls. Yes!

If it opens in a visible state go to Window>Hide and again save it.

As far as distribution of macros to other users goes........

It is not a good idea to overwrite other users' personal.xls with a copy of
your own.

The add-in method makes for easier updating of your macros.

Send the add-in to users and they can load it through Tools>Add-ins.

True...you will not see the macros listed in

Tools>Macro>Macros if you use an

 

[Vic Eldridge]

Colors gleaming in the sun, dancing with each passing breeze

rising thru the air into the sky. Drifting from the soft embrace
a gentle cloud & breeze below, so like a spirit does it lie.

Doesn't sound like any of my macros !