Adding a button function?

A

alchy

would like to add a small gfx object that looks like a button in my
spreadsheet.
When someone clicks on it i would like it to perform a function.In my
case to reset all data to 0.

How can i do this and also after they click it how would i add a
validation "are you sure you want to reset all data to 0?" as a
security measure so they don't delete by mistake?

Im very new to this but this is the only function i need to add to my
sheet to finish my project

Regards Alchy
 
C

Cole

I think you first need to record macro and then assign the macro to the
button
if you need help on macro or VBA

try news group microsoft.public.excel.programming
to make the button use menu bar -> view -> toolbars -> forms, if it is not
on desktop already, you should see the buttons you need.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top