Hi,
I have some macros contain with workbook name in the beginning, what's wrong with it please? How can I fix the issues?
Many Thanks
J
June 10, 2024
HansV MVP - Ashish Mathur - Andreas Killer - Jim_ Gordon - Rich~M ✅
Hi,
I have some macros contain with workbook name in the beginning, what's wrong with it please? How can I fix the issues?
Many Thanks
J
Reported content has been submitted
* Please try a lower page number.
* Please enter only numbers.
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
If you have an addin or global template with some macros, the file name for the other files will be added before the macro names you are using from those files..
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Hi,
I have only 1 workbook, but some macros code are built by the blogger.
Many thanks.
J
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Hi,
I have only 1 workbook and I always selected “This workbook” on the Marco Name pop up, but the some those macros are built by the blogger.
Many thanks.
J
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Created by who?? And create where? You speak in riddles, show us the file.
If your file contains confidential data simply clear the cells, data doesn't matter for this.
IMPORTANT: Zip your file!
https://support.microsoft.com/en-us/windows/zip-and-unzip-files-8d28fa72-f2f9-712f-67df-f80cf89fd4e5
Login to https://onedrive.live.com (Use the same Login ID and password as for this forum).
Click Upload in the top and choose your file.
After uploading, right click the file and choose Share.
Click Copy Link in the lower left edge (no need to enter an email).
Copy the link and paste it here.
Andreas.
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Hi,
The Marcos’ Name look like this:
‘Book1.xlsm’!Module1.Macro1
‘Book1.xlsm’!Module2.Macro2
In general, Macro1 and Macro2 are the macro names, aren’t they?
What’s wrong with it please?
Many thanks,
J.
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Hi,
Someone created the Marco for me, and I copied and pasted to my workbook (I edited directly at Visual Basic Editor > Insert > Module), but the Marco Name looks like this:
‘Book1.xlsm’!Module1.Macro1
‘Book1.xlsm’!Module2.Macro2
What’s wrong with it please?
Many thanks,
J.
Reported content has been submitted
1 person found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
J,
There is nothing wrong, again: Show us the file.
Andreas.
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Hi,
Someone created the Marco for me, and I copied and pasted to my workbook (I edited directly at Visual Basic Editor > Insert > Module), but the Marco Name looks like this:
‘Book1.xlsm’!Module1.Macro1
‘Book1.xlsm’!Module2.Macro2
What’s wrong with it please?
Many thanks,
J.
There is nothing "wrong". This is just excel's way of telling you where the macro code is hidden.
In your example, both macros are in a workbook called "Book1.XLSM"
The first macro is in a subdivision called "Module1"
The second macro is in a subdivision called "Module2"
.
You'll see the various places in your workbook that macros can be hidden (sheets/tabs and modules) in the macro editor
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.