I know how to create a text link to other cells within a work book but how can I create a button which will do the same?
Thanks for your help
I know how to create a text link to other cells within a work book but how can I create a button which will do the same?
Thanks for your help
Last edited by jaywizz; 08-03-2009 at 09:42 AM.
1 record a macro so say your button is going to be on sheet 1
select sheet 1
tools /macros/record new macro
give it a name eg gotosheet3cella1
start recording
click sheet3 click cell a1.
then
tools macro stop recording. thats it macro done
now from the forms tool bar select a button an put it on sheet 1
as you do the assign macro window wil pop up
click the macro name you just recorded click ok
click anywhere on sheet away from button to exit edit mode.
now click the button and you are taken to sheet3 a1
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks for that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks