Thread: How to write a marco in Excel to delete worksheet?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ko06879 ko06879 is offline
external usenet poster
  
Posts: 1
Default How to write a marco in Excel to delete worksheet?

Dear Friends,

Do you know how to write a marco in Excel to delete worksheet
automatically, without prompting me to click OK?

I have tried one by using the command:
Sheets("Sheet2").Delete

but it will ask me to click OK before delete it. It looks not
professional.

Thanks a lot.


--
ko06879
------------------------------------------------------------------------
ko06879's Profile: http://www.excelforum.com/member.php...o&userid=34149
View this thread: http://www.excelforum.com/showthread...hreadid=539188

Reply With QuoteReply With Quote