Thread: deleting wksts
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kaj1104 kaj1104 is offline
external usenet poster
 
Posts: 1
Default deleting wksts

Guys I have a problem

I created these procedures to execute when the file is opened. Th
Base Wksht gets created, however if I open it up again and the bas
wksht is already there it gives me an error. I need to have the bas
wkst recreated every time the file opens. So basically base wkst need
to be deleted before the program steps in copyinsameworkbook.

Can you guys help me out?


Sub auto_open()

CopyInSameWorkbook
End Sub




Sub CopyInSameWorkbook()
' Copying the entire sheet
Sheets("x").Select
Sheets("x").Copy Befo=Sheets(2)
Sheets(2).Name = "Base"
End Su

--
Message posted from http://www.ExcelForum.com