Monday, August 16, 2010

How do i create a button on Microsoft Office Excel 2007?

i have office 2007 on vista, i want to create a button to clear data on a worksheet, can this be done??



How do i create a button on Microsoft Office Excel 2007?hp



Tools -%26gt; Macro -%26gt; Record New Macro...



Click ''OK'' and clear your data manually. Click the stop button on the macro recorder.



Then go to View -%26gt; Toolbars -%26gt; Forms, and a new toolbar should appear. Click the fourth button from the left, which looks like a button with no label. Draw the button anywhere you want on the sheet, then select the macro you just recorded when it asks (usually Macro1, unless you named it before you recorded it).



Now, every time you click that button the same actions you recorded will be repeated.

No comments:

Post a Comment