Adding a button function?

  • Thread starter Thread starter alchy
  • Start date Start date
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
 
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.
 
Back
Top