Catalin

Four of my worksheets have the following code, but each one has a different Set ws = Sheets (" ").  They are  "OR CST Scrub", "OR ASTs", "OR RNs"

 Application.ScreenUpdating = False
    Set ws = Sheets("7J Ante")
   
    'Create temp sheet
    Sheets.Add.Name = "MyTemp"
    Set ts = Sheets("MyTemp")
   

The sheets were already created, there are no new sheets being added. The workbook is protected, so does the macro add a temp sheet each time it is activated?  Is this the problem?

Hi Melinda

Based on the macro you provided, the MyTemp sheet will be deleted unless the macro encountered and error before that and fail to delete it.

In that case, you will need to manually delete the MyTemp sheet.

Catalin have already mentioned the likely cause of the error.

Can you post the file for us to have a look?

Sunny