Hello,
I have a quick and hopefully very easy question.
I have this code that runs several macros for me:
My question is can I take out the "working.xls" part and put something else in its place? This spreadsheet will be taken by many people and renamed, etc...
Please Login or Register to view this content.
I noticed that when I rename the spreadsheet, the macro's fail because it can't find working.xls
Any suggestions/comments would be greatly appreciated.
Thanks,
Adam Parker
The macro must belong to "Working.xls" workbook. I think once you "save as" the originating workbook is no longer open and the macro would no longer be available.
You could put the macros in a "personal.xls", place that on each computer and they will have access to the macro regardless of the active workbook name.
Please Login or Register to view this content.
Regards
Rick
Win10, Office 365
Is this code contained within the same workbook as the macros it's calling, or is it in a different workbook?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks