Copying a macro to multiple docs
Closed
Kat
-
Feb 26, 2010 at 03:23 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 26, 2010 at 03:48 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 26, 2010 at 03:48 PM
Related:
- Copying a macro to multiple docs
- How to delete multiple files at once - Guide
- Allow multiple downloads chrome - Guide
- Spell number in excel without macro - Guide
- Google docs not showing spelling errors - Guide
- How to download a google doc with comments - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 26, 2010 at 03:48 PM
Feb 26, 2010 at 03:48 PM
You can have macro save in an xla file. So each time excel opens, macro is available
or in a new book have some thing like this
Sub AddModule(myBook As Workbook, myModule As String)
myBook.VBProject.VBComponents.Import myModule
End Sub
and define your book and module to import
or in a new book have some thing like this
Sub AddModule(myBook As Workbook, myModule As String)
myBook.VBProject.VBComponents.Import myModule
End Sub
and define your book and module to import