Puzzle attached: Sub not executing every time. Plays up depending on what sheet is active

Hi All

Hopefully someone clever can figure out what is going on in this workbook

In each SLA sheet there are 2x form control buttons to add / delete sheets
When any sheet with name beginning 'SLA...' is active, 'add new sheet' button does not fire on first click 80% of the time (same for the execute button in the VBA editor, it's hit or miss)

However it works 100% of the time if run from any other sheet?! (any sheet where the name does not begin 'SLA...')
It also works every time in the VBA editor if I use the F8 key to step though?

So basically it doesn't work properly in the one place I need it to, on the SLA sheets >.<

The idea behind the 'Add New Sheet' button is that it calls a macro called Listsheets() first.
This lists all the sheets in the workbook that begin 'SLA... in Sheet5.CellsB37 onwards.

Sheet5.CellB34 then displays what the next added sheet should be called

At the end of Listsheets() macro NewSLASheet() is called, which adds a new copied sheet & names it per the value in Sheet5.CellB34

As far as I can tell the problem seems to occur right from the start with Listsheets() not firing?

I am lost on this one, so any advice would be greatly appreciated
Many thanks in advance
Vicky

The macro stops after line Sheet5.Range("B37:B100").ClearContents (Sub Listsheets)
I think the worksheets named SLA... contain something with error formulas. So when Sheet5 change, the formulas recalculate, the error occurred and the macro stops.
To solve this proplem, you should prevent the formulas recalculate by Application.Calculation command

Please Login or Register  to view this content.

Thank you so much! There's never a day I don't learn something new when I'm on this forum