On Feb 6, 10:04*pm, joel wrote:
th seasies wasy is to manual go to each sheet selecting the sheet in the
vba project window and then tyhpe Cntl-A (select all) and press delete.
It only should take 2 minutes.
You can easily delete all the sheet by selecting all at once and
starting from scratch. remove the vba code. *Then write a very simple
macro to create the sheets
for I = 1 to 50
sheets("sheet1").copy after:=sheets(sheets.count)
next i
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=176984
Microsoft Office Help
You have to use VBIDE class.
To get that you will have to add "Microsoft Visual Basic for
Applications Extensibility x,xx" . Then you can write a macro to
delete the entire code in 2 sec.