Compile Error: Ambiguous Name Detected: Workbook_Open

Hi all,

I have the following two codes, which go in ThisWorkbook module:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

The first code forces the user to enable macros, and the second code tracks the opening and closing of the workbook. The Tracking Log worksheet is "xlSheetVeryHidden" and the TestFile workbook is hidden.

How do I put them in the same ThisWorkbook module without getting the "Ambiguous name detected: Workbook_open" error?

Thank you,
Gos-C

You need to place your code in Standard modules & call them from the Open event

Thank you for replying, royUK.

I placed the codes in standard modules. How do I call them?

Thanks,
Gos-C

Replace macro1 7 macro2 with the names that you have given your new macros

Please Login or Register  to view this content.

Hi royUK,

Thanks again for your guidance.

After several tries, I finally got it to work. I kept everything in ThisWorkbook, called the TrackOpen code, and declared some undeclared variables.

Can you please review and advise if everything, especially those in red letters, is okay.

Here is the code:

Please Login or Register  to view this content.

I appreciate you help.

Thank you,
Gos-C

I wouldn't place the non workbook code in the workbook module, but in a separate module.

Please Login or Register  to view this content.

Then in the workbook module

Please Login or Register  to view this content.

Hi royUK,

I added the following to the standard module:

Please Login or Register  to view this content.

and added:

Call TrackClose after the Call HideAllSheets line in the workbook module, and everything works fine.

Thanks for your help.

Gos-C