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
Try completing the expression with workbook reference, e.g.
ThisWorkbook.Sheets("Mainsheet").Select
or
Workbooks("something.xls").Sheets("Mainsheet").Select
Jimmy
-------------------------------------------------
The more details you give, the easier it is to understand your question. Don't save the effort, tell us twice rather than not at all. The amount of info you give strongly influences the quality of answer, and also how fast you get it.
Q: Is the Sheets ... outside of the Sub?
Q2: why is the 'Sub line commented out?
1. Maybe your sheet is hidden.
2. Maybe your sheet doesn't have that name.
Charlize
Posting Permissions
Reply With Quote
