command button

  • Thread starter Thread starter singkit
  • Start date Start date
S

singkit

Please help!

I'd like to have a command button on my work sheet

e.g.
sheet1, sheet2,sheet3

Sheet 1 is my home, I will put the command button on
sheet 2 can you give me a specific macro for command
button that when I click it will go to sheet1 at range
(e.g. A1:c32)

Best regards!
Thanks!
 
Maybe the smart ones have a quicker way - but..

go to sheet two, turn on the macro recorder, then click on
sheet one, go to desired cell. Stop recording. Assign a
button to macro, put in tool bar or add a hotkey..
 
Back
Top