View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Personal Macro Workbook

Use a add-in Graig

One way
http://www.rondebruin.nl/qat.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Craig" wrote in message ...
Hi

I know that the Personal.xlsb file is stored in the C:\Users\user
name\Application Data\Microsoft\Excel\XLStart folder of each computer in
Vista/Office 07


MY QUESTIONS A

1. Whats the best way to get personal macros from my C drive on my computers
to be available for use across a network so anyone can start Excel and be
able to run my personal macros and hopefully not overwrite any of their
personal macros?

2. I want to take my personal macros from one laptop and put them to use on
another laptop. Do I export the Personal file to a bas file on the laptop to
send from let say onto a flash disk, and them import them into the other
Personal file on the computer to receive via the flash disk? Is this the
best way?

Thank you!

Craig