Deleting sheets
 

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

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

Deleting sheets
 

The only thing in the Knowledge base about this error is this

Can't Enter Break Mode" Stepping Through a Macro
http://support.microsoft.com/default...51&Product=xlw


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Harald Staff" wrote in message ...
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