LinkBack URL
About LinkBacks
Good morning,
I have a macro that was initially created in a specific Workbook. I would now like to recreate it (or basically copy the code) in the Personal macro Workbook.
Is this an easy process?
Many thanks,
Regards,
Martin
Good morning,
I have a macro that was initially created in a specific Workbook. I would now like to recreate it (or basically copy the code) in the Personal macro Workbook.
Is this an easy process?
Many thanks,
Regards,
Martin
Hi Martin
When you first create a macro you have the option to store it in the particular workbook you are working on or make it available to all workbooks. If it is current available only to a specific workbook you can copy it to a new workbook and make it available to all workbooks.
Hope this helps.
Tony
Hi Tony,
That's great!
Many thanks,
Martin
Hi Martin,
it depends how the code was written and whether it works with different worksheets within the workbook and what it does
Generally, copy and paste the code in a module in your VBAPproject(Personal) and replace any bits of ThisWorkbook in it (if such exist) with ActiveWorkbook
Howver, unless the code is very general and applicable to variety of workooks, I wouldn't move it to Personal
Liked the answer given? click * to say so
Yes - you just copy and paste the macro into your personal.xls workbook...
See here for more:
http://office.microsoft.com/en-001/e...102174076.aspx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks