Can I delete a sheet stepping through a macro ie 'in break mode'?

[berlinhammer]

Hello

I am trying to write a program and step through but am encountering an irritating problem. I need to delete a sheet but the warning keep forcing me out of break mode. Disabling the Application.DisplayAlerts does not seem to be working.

I won't get the error when I run the code but as I am currently in construction and do not want to run the full code yet, I just want to step through one step at at time and this sheet deleting is preventing me doing so, which is proving a bit of a pain.

Can I do this the way I would like?

Thanks

Jon

Sub example()

    Application.DisplayAlerts = False
    ThisWorkbook.Sheets(3).Delete
    Application.DisplayAlerts = True

End Sub

 

[dave3009]

That should work OK when you step through the code using F8, is there workbook protection on by any chance?

 

[berlinhammer]

I'm not sure Dave I certainly didn't intend to protect it.

Have you got a code snippet I can check with by any chance?

?wsN.ProtectionMode is giving me false in the immediate window.

My move worksheet method is failing on this sheet also, so you may be onto something there but I'm not sure how to check for my protection settings on the sheet?

Thanks for replying

Jon

 

[berlinhammer]

I haven't got a decisive code but I've been fiddling about in any thing to do with Properties I can and I do not think it is protected.

 

[dave3009]

Check the workbook structure, Tools>>Protection or Review Tab if using Excel 2007 + and see if Unprotect Workbook is an option.