View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default deleting worksheet

Hi
use something like
...
application.displayalerts=false
'delete the sheet
application.displayalerts=True

--
Regards
Frank Kabel
Frankfurt, Germany


Fun Kid wrote:
What line of code should I include while deleting a worksheet through
VBA so that the security feature (The selected sheet(s) will be
permanently deleted.) is disabled. Right now I have to click "OK"

for
the code to continue. Any suggestions?