MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Creating Worksheets Using a Macro


Posted by Pete on September 09, 2001 8:14 PM

To anyone who can help.

Is there any way to create a worksheet using a macro? (i.e. not clicking insert --> worksheet nor right clicking a sheet tab --> insert then double clicking worksheet.)

Thanks.


Posted by Tom Urtis on September 09, 2001 8:29 PM

The short answer to your question is Yes, with the code line "Sheets.Add" in a macro.

Tom Urtis

Posted by Pete on September 09, 2001 10:48 PM

To anyone who can help.

Thanks Tom for your help. However after I create this sheet I wish to remove the grid lines, fill all the cells in pale blue, insert some word art, insert the date when the sheet was created and enter borders and other certain data. Further more I wish to create a reference to this sheet with a button that links to the sheet. Is it possible to do all this with a macro.

Thanks.

Posted by Tom Urtis on September 09, 2001 11:43 PM

Yes it's possible to do all that using VB. A good way to familiarize yourself with VB is by carrying out those tasks in a recorded macro and then going back and studying the code in the VBE.

Posted by Pete on September 09, 2001 11:47 PM

Thanx Tom. You have been a great help.