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?

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.

"Lynn" wrote:

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?

The direct to part could be done using InsertHyperlink and no button.

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


Gord Dibben MS Excel MVP

On Wed, 4 Jun 2008 07:11:01 -0700, Lynn wrote:

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?