Thread: Deleting sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Deleting sheets

Your code works fine here -assuming that the "Are you sure?" message is a sensible
response.

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Gary Adamson" wrote in message
...
When I try to run a macro to delete sheets in my workbook
I get an error saying "Can't enter break mode at this
time". How can I disable or keep this from ocurring?

ie:

Sub test()
Sheets(Sheets.Count).Delete
End Sub