Buttons

B

bfriederichs

Okay, I tried following the instructions in the Help file, but to n
avail. What I'm trying to do is assign a macro to a command butto
that will let me go from one tab of the file to another. Like goin
from Sheet 1 to Sheet 15. Any help would be appreciated.
 
J

JulieD

you didn't mention where you got stuck - is it with the macro or with the
button?

a macro to take you from sheet 1 to sheet 15 would be

sub movesheets()

Sheets("sheet15").activate

end sub

this macro will need to be copied & pasted into a module sheet of the
workbook (right mouse click on a sheet tab, choose view code ... choose
insert / module - copy & paste code in, close VBE window)

to create a button to take you there - i personally like using the
autoshapes on the drawing toolbar, click on the autoshape you want, click
somewhere on sheet 1 - there's the button - to add text, right mouse click
on it and choose "add text", to assign it to the macro, right mouse click on
it again and choose "assign macro" ... find movesheets in the list and click
OK

let us know how you go

Cheers
JulieD
 
Top