Can't enter break mode only sometimes

Originally Posted by carsto

The reason I’m changing the codename is because regardless of what the user may do, I want to insure that this newly created CostDate sheet is ALWAYS DELTED prior to the creation of another.

I don't know why it errors.

Instead of changing the code name, couldn't you just loop through the sheets and delete them by name.

Dim ws As Worksheet
Application.DisplayAlerts = False
For Each ws In Worksheets
    If ws.Name Like "Cost*-*-*" Then ws.Delete
Next ws
Application.DisplayAlerts = True