maryam
05-08-2007, 10:44 PM
I got this error Runtime error '1004': Select Method of Worksheet class failed and the bold part is yellow. I just add one control to my command bar and then I recieve this error when I start.
Sheets("Mainsheet").Select
'Sub AssignMacros()
With Application.CommandBars("Object Palette1")
With .Controls("&Drawing")
.OnAction = ""
End With
With .Controls("&Select Objects")
.OnAction = ""
End With
Sheets("Mainsheet").Select
'Sub AssignMacros()
With Application.CommandBars("Object Palette1")
With .Controls("&Drawing")
.OnAction = ""
End With
With .Controls("&Select Objects")
.OnAction = ""
End With