I have a very complicated macro saved to my personal.xlsb that I want to copy into a workbook which would allow me to send the workbook to another user and they can use the macro also. Can the macro be copied into the workbook or do I have to re-build it?
Hi,
Yes you can just copy the macro text and paste it into any other workbook.
If it's the only macro in the module then you could export the module with File Export in the VBE, and then in the other workbook File Import.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks