Moving or Copying tab error messages

[Katstang]

I am hoping someone can explain why I am getting an error message when I copy a tab. I have attached the message. I have to click the "YES" button it seems like a hundred times for the command message to go away. What causes this? What is the fix? Clicking No is not an option either. Thanks in advance to anyone that can help me out.

 

[VBE313]

If you put in your code at the top...

Application.EnableEvents = false
Application.DisplayAlerts = false

and then at the bottom

Application.EnableEvents = true
Application.DisplayAlerts = true

 

[Katstang]

VBE313, Not sure that I am following your solution. I am not running any codes in the file that I am working in.

 

[Fluff]

You are getting that message because the sheet you are copying contains a named range that is workbook scope.

 

[Katstang]

Fluff, what is the fix? What is "Workbook scope"?

 

[Fluff]

It really depends on how those names are being used.
One way would be delete them & then re-create them with worksheet scope, but that may require a lot of work to get the workbook working again.

 

[Katstang]

For my workbook, I think I will just delete the "Named Ranges". Did some further research and I have no formulas that can be damaged by using "Named Ranges". Thanks for the assistance.

 

[Fluff]

You're welcome & thanks for the feedback.

For safety I would recommend creating an archive copy, before deleting the names, just in case.