Thread: Macros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Macros

create your presonel.xls on other folder and than copy to the startup folder

hth
regards from Brazil
Marcelo

"Cincy" escreveu:


I am trying to create some macros in Excel that will be available
whenever I open any Excel spreadsheet so I think I need to store the
Macro in my Personal Macro Workbook. When I click record macro and
select store macro in Personal Macro Workbook it is unable to record
the Macro and says "Personal Macro Workbook in the startup folder must
stay open for recording". How do I set my computer so the personal
macro workbook in the startup folder stays open?


--
Cincy
------------------------------------------------------------------------
Cincy's Profile: http://www.excelforum.com/member.php...o&userid=35172
View this thread: http://www.excelforum.com/showthread...hreadid=558586