Removed Records: Object from /xl/worksheets/sheet3.xml part

[Deniouz]

I am having a problem with the create new worksheet code. Every time I create a new worksheet, save and close, an error message "Removed Records: Object from /xl/worksheets/sheet3.xml part" appears when i reopen the file. What went wrong with my code? I did used

Please Login or Register  to view this content.

for a few lines. Could this be the source of this error?

The sample provided is before creating any new worksheets. Everything is fine till a new worksheet is created, saved, closed then reopened.

[Keebellah]

Does your file have a custom ribbon defined? This generally pints to invalid references
I'll check your file but this is just the first thing that comes up

[Keebellah]

You've got an invalid macro reference to the button Lock/Unlock the rest I don't know
Please explain it a little better

[Deniouz]

Hello Keebellah..
I do not have any custom ribbons..

As for the lock/Unlock button, it works like normal.. The only problem with the lock/unlock button is that the image is gone when a new worksheet is created, however, the button still functions normally.. I have removed it from the macro so that any reviewer could focus on the create new worksheet macro.. the macro for the lock/unlock buttons are as follows:

Please Login or Register  to view this content.

[Keebellah]

The create new worksheet macro works perfectly.
About the lock/unlock button, why is the image disappearing? You could create place an image as button.

[Keebellah]

I see what you meant. the issue is the Luck/Unlock button. THAT's the item that's being removed and causes the problem after you create a new worksheet

[Deniouz]

Thanks for pointing what what caused the error. And all the while I thought that the error came from my code. How do I fix this error?

[Keebellah]

Change the button to an image and link the macro to that

[Deniouz]

It works now.. thanks Keebellah..

[Keebellah]

Great
Happy Holidays and happy coding for 2021
Don't forget to mark the post as Solved (under Tools)