edit configure add button and code

  • Thread starter Thread starter swain.s
  • Start date Start date
S

swain.s

where can i get infomation to edit and coinfigure add button and code to save
data on a sheet to another sheet
 
Hi,

To get the code - turn on the recorder and do the steps you want the macro
to do - choose Tools, Macro, Record New Macro. Give the macro a name without
spaces and click OK. Do the steps. Turn the recorder off - choose Tools,
Macro, Stop Recording.

For a button - right-click any toolbar and choose Forms. Click the Button
button and then click or drag in the sheet. When you release the mouse the
Assign Macros dialog box will appear, pick your macro.

Test, and get back to use with questions if necessary - as a new post.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire
 
this is not doing what want i am trying to put buttons on the worksheet :-
save, edit, cancel
 
Back
Top