"Ambiguous Name Detected" and other button problems

[UWBadger]

I have a series of 12 buttons in one sheet of a multiple sheet workbook that all need the same basic code (see below). The code created for Button_1 worked...so I copied, pasted, and edited that code for the other 11 buttons. None of the other ones will work! For some of the buttons, I get a "Ambiguous Name Detected" error. For others, I get: "Cannot run the macro '(name of macro)'. The macro may not be available in this workbook or all macros may be disabled." Can anyone help? Is there a common cause for these errors?

The code in question:

Please Login or Register  to view this content.

etc...

[mehmetcik]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Rick Rothstein]

That "Ambiguous Name Detected" error usually means you have two procedures with the exact same name.

[UWBadger]

I think I found my problem. I have other buttons in this same workbook (on other sheets) with the same name (number). Is there a way to avoid this?

[UWBadger]

Problem solved by deleting malfunctioning buttons and adding new buttons that had non-duplicative names.

[Kyle123]

You’d be a lot better off with normal buttons on the sheet rather than activex and assigning them all the same macro

[mjr veverka]

... solved by deleting ... buttons and adding new buttons ...

If you have many short macros for buttons and you don't want use the class module, then maybe use (???) such a structure as below.
The code will be clearer for reading and checking:

Please Login or Register  to view this content.