macro in every workbook - Personalize

gsrikanth

Board Regular
Joined
Jan 7, 2012
Messages
209
Can i run my macro in every new workbook. or in already existing workbook.
Can any body help in personalize?
Thankyou
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

ranman256

Well-known Member
Joined
Jun 17, 2014
Messages
1,887
Record a macro, select PERSONAL workbook,
click any cell, stop recording,
enter VBE (alt-F11)
open module1 in personal wb, remove the macro made above,keep module.
copy your macro needed from the source workbook to the personal workbook,module1.
save

now the macro will work in any wb.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,099,471
Messages
5,468,820
Members
406,611
Latest member
hanman453

This Week's Hot Topics

Top