Call command buttons by user-defined names

[Willardio]

right now this code calls one in a series of subs based on text from a cell. I want to call command buttons with the same names instead, so that i can use application.caller to not have so many nearly identical sub routines.

Please Login or Register  to view this content.

Any suggestions would be greatly appreciated!

Willardio

[Willardio]

Here's the situation: there are command buttons on each page so that users can add a page (43 rows and a page break). Additionally, the macro above is used to call the same set of nearly identical macros for a new page in which to import word documents from other workbooks.

[OllieB]

Willardio, please post a copy of the workbook. That would make it easier to understand and write

[JosephP]

if they are forms buttons

Please Login or Register  to view this content.

if they are activex then you have to use a class or explicitly pass the name of the control-application.caller won't work