Excel error pop up associated with a specific sheet of my file

[Naz555]

Hi guys,

Hope all is well.

i have been working with this particular file for a few weeks now. It is a dynamic document which involves a heavy amount of VBA codes as well as regular insertion and deletion of worksheets. However, whenever the file contains worksheet4, the following error pops up, which if clicked yes, then displays the second pop up. This only happens when I have sheet4 in my file. Is there a wqay to not have sheet4 in my file?

error.jpg

[Keebellah]

Delete Sheet4

[Logit]

.
Or, re-write it from scratch. Do not copy and paste 'cuz you'll probably copy whatever it is that causes the error. The sheet is most likely corrupted some how.

[Naz555]

.
Or, re-write it from scratch. Do not copy and paste 'cuz you'll probably copy whatever it is that causes the error. The sheet is most likely corrupted some how.

Nope, there is a master template which the macro uses to create other sheets. So there are a couple of other sheets you have to create, which are exactly similar to sheet4 before you get to it

[Logit]

.
Without having your workbook 'in hand' to review here, it is going to be very difficult to trouble shoot the error for you. The quickest way, if you are agreeable, is to post the workbook for others to review.
Remove all confidential data prior to doing so.