Why does my macro names include the filename?

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..

Hi,

I have only 1 workbook, but some macros code are built by the blogger.

Many thanks.

J

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

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.

Do the macros look something like this:

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.

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.

J,

There is nothing wrong, again: Show us the file.

Andreas.

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