-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
macro in every workbook - Personalize
ranman256
Well-known Member
- Joined
- Jun 17, 2014
- Messages
- 2,382
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.
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:
Upvote
0
