scubadivingfool
New Member
- Joined
- Jun 17, 2010
- Messages
- 35
Looking at using a CommandButton on Sheet1 that calls a macro that I have in Sheet5. When I run the macro straight from Sheet5 it works perfectly, but when I run it from the CommandButton on Sheet1 nothing happens. The code is listed below that I am using in the CommandButton to call the maro in Sheet5. I have also tried the Code without the "Public" and just calling the Sub but sill nothing works.
VBA Code:
Public Sub FilterColorToRed()
Call Sheets("Sheet5").CommandButton3_Click
End Sub