Button vs Command Button
Hi
Adding to Tom:
Try a hyperlink, the blue underlined navigation thing as in a webpage.
Insert Hyperlink menu. No code, intuitive user interface when done.
HTH. Best wishes Harald
"Dan" skrev i melding
...
I have a workbook where I used a button and assigned the following macro:
Private Sub T12_Click()
Sheets("T1-05").Select
Range("A17").Select
End Sub
In revamping the sheet I used a command button and loaded the code in to
it.
Works fine in the button, in the Command button I get a Run-time 1004
Select
method of Range class failed. Why is this happen. A17 had data in it
though
it is linked from another sheet in the same workbook
Secondly if you have a sheet that uses many buttons mostly for navigation
which would be the better route the macro with the button or the coded
command. Trying to keep file size down. Thanks
|