add or copy a sheet by button

G

ghost

Greeting,
I have a worksheet and what I want to do is making 2 buttons for add new
sheet and other for copy the sheet. How to do that please??
Many thanks
 
G

Gord Dibben

Tools>Macro>Record new macro to get the code.

The buttons can be either placed on a Toolbar or just a button on the sheet.

1..Tools>Customize>Commands>Macros. Drag a smiley face up to a Toolbar and
assign the macro.

1. View>Toolbars>Forms. Select the button tool and create a button on the
sheet. Right-click and assign macro.

BTW.............both of these commands are available.......Insert>Worksheet

Right-click on a sheet tab and "Move or Copy">create a copy.


Gord Dibben MS Excel MVP
 
Top