Command button to call other buttons help

[Luis_B]

Hi Guys,

I created three command buttons, one in a different tab. Each button works finds individually. I create another button in a separate tab that is not in any of the first three tabs. The last button is to call the other three buttons. I have done this before with other spreadsheets but with this VBA, I get an error when the button tries to call the second CommandButton. Also, the last button that I'm using to call all the first three buttons works if I only call one button at the time but I get an error if I try to call multiple buttons at once

Any help would be greatly appreciated.

Thank you,

Sub CommandButtonAll_Click()

Call Sheets("Worksite").CommandButton1_Click
Call Sheets("Worksite 3").CommandButton2_Click
Call Sheets("Worksite 4").CommandButton3_Click

End Sub

 

[LazyBug]

Hello!

Does your last button code in a Sheet code? If yes, try to move it into a Module.

 

[LazyBug]

Hello!

Does your last button code in a Sheet code? If yes, try to move it into a Module.

Although, unfortunately, i can't repro your problem. The only offer that i give - check your buttons names.

 

[Luis_B]

Although, unfortunately, i can't repro your problem. The only offer that i give - check your buttons names.

Thank you LazyBug. I had an error in my code related to the name of a sheet. It is working now