Insert Command Button that will Activate Command Button on a Different Sheet

Hello everyone,

I have a command button on sheet 5 that I would like to be able to activate from sheet 2. I have tried to just run the same Macro on sheet 2, but when I try to make the Macro reference sheet 5 I am getting errors. Can some either help me with the code, or explain how I could have the button on sheet 2 activate the button on sheet 5.

Original Macro on Sheet 5

Please Login or Register  to view this content.

Attempt at Macro on Sheet 2

Please Login or Register  to view this content.

Hi realvirtuality1,

It is not clear what you want since you did not provide a sample workbook.

My understanding is that you want "Sheet5" cells W14 and J36 all the time, no matter what sheet your are on. If this is the case:
a. Create a macro that works in an ordinary code module such as Module1:

Please Login or Register  to view this content.

b. Create a Shape or Forms CommandButton on 'Sheet5' that is assigned to Macro solver11().
c. Copy the Shape or Forms CommandButton to the other sheets as required.

See the attached sample file.

Lewis