add or copy a sheet by button

  • Thread starter Thread starter ghost
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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

Similar Threads

Excel Move or Copy Stopped Working? 0
Need to merge worksheets - Excel 2003 0
Cannot copy worksheet to another file 2
Formatting problem copying sheet 3
copying macros to other sheets 3
problems getting this macro to work 23
How to insert new worksheet based on # of rows in a data sourch 2
Copy Sheet to new Sheet and clear cells on original sheets 7

Back
Top