Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,562
- Office Version
- 365
- 2016
- Platform
- Windows
I am having difficulty assigning a macro to a grouped shaped. I took this from a recorded macro:
It is included in this code ...
The OnAction line is giving me the error : "Object doesn't support this property or method"
Code:
wsfront.Shapes.Range(Array("grp_login1")).OnAction = "TimeClock.xlsm!Login.login"
It is included in this code ...
Code:
Private Sub Workbook_Open()
Declarations
wsfront.Shapes("txtbx_msg1").Visible = True
wsfront.Shapes("txtbx_msg2").Visible = False
wsfront.Shapes.Range(Array("grp_login1")).OnAction = "TimeClock.xlsm!Login.login"
Application.OnTime Now + TimeSerial(0, 0, 1), "UpdateTimer"
End Sub
The OnAction line is giving me the error : "Object doesn't support this property or method"