Addins, Personal Workbook, Default Macro Record Local

Engineer Joe

Well-known Member
Joined
Jun 10, 2005
Messages
543
Hey everybody...i got a problem here. I opened my personal workbook from the background and did a "save as" and made it an add-in on my company's network drive. I didn't save changes to personal workbook when I closed out though. My problem is that now when I record macros, the default location to record them is in the currently viewed file instead of my personal workbook. I don't wanna transfer them over forever. Is there a way to set my default folder for the macro recorder??
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,118,436
Messages
5,572,099
Members
412,441
Latest member
kelethymos
Top