Excel Macros

C

costin

Hi,

i would like to back up all my macros i have about 30 of them, i would want
to back them up to my drive on the network but i cannot find where they are
located. are they in a folder where i can just copy paste?
 
D

Duke Carey

If you've recorded them and saved them in your Personal workbook:

Go to Window|Unhide & unhide Personal.xls

Do a File| Save as and you'll see where to find it.
 
J

JP Jones

I preseme you macros are located in your personal.xls file. If so this can be
found at:

"C:\Documents and Settings\<Your User Name>\Application
Data\Microsoft\Excel\XLSTART\PERSONAL.XLS"
 
D

Dave Peterson

You have an answer to your question in .excel.
Hi,

i would like to back up all my macros i have about 30 of them, i would want
to back them up to my drive on the network but i cannot find where they are
located. are they in a folder where i can just copy paste?
 
Top