How do I create a button on a spreadsheet ?

L

Lynn

I would like to create a button on a spreadsheet that I can click on to
direct me to a certain section of the sheet, or a button I can click on that
will "delete all customer information"
Is this possible? How do I create it?
 
D

Dave

Hi,
The button part is easy.
View > Toolbars > Forms
From the Forms menu, click the button icon
Click on your sheet where you want the button.
While the button has hashes around it, you can edit its size and text.

The button will do nothing by itself.
You have to write (or record) a macro and make the button run it.
 
G

Gord Dibben

The direct to part could be done using Insert>Hyperlink and no button.

For the macro assigned to a button, see Dave's reply.


Gord Dibben MS Excel MVP
 
Top