tbaker818
12-16-2014, 02:38 PM
I have some very simple code that works with a regular macro button but not an ActiveX button. I just activate a different sheet and select range A1. Selecting range A1 produces "Select method of Range class failed" error. I found through some debugging that it's looking at the A1 on the sheet where the button resides, not the one that has just been activated. This seems to be a real problem. How can I work around this? :banghead: Again, identical code is fine with standard macro button. Code:
Private Sub CheckInCycle_Click()
Sheet25.Activate
Range("A1").Select
End Sub
Private Sub CheckInCycle_Click()
Sheet25.Activate
Range("A1").Select
End Sub