To delete a sheet try this:
'Turn off user prompt
Application.DisplayAlerts = False
'Assuming the worksheet you want to delete is called data
Sheets("data").Delete
'Turn back on user prompt
Application.DisplayAlerts = True
Hope this helps
B
tanyhart Wrote:
I have a macro that will create data sheets based upon the main
worksheets information.
What I was wondering is, upon exiting the file, can I have excel delete
those created sheets so that when the file is opened again the macro can
be run and new data presented?
Thanks
--
ben77
------------------------------------------------------------------------
ben77's Profile:
http://www.excelforum.com/member.php...o&userid=35602
View this thread:
http://www.excelforum.com/showthread...hreadid=554671