So this is a new problem and I am wondering if anybody else is seeing it. I have several excel workbooks with VBA code in them that do a variety of things on button clicks. All worked fine till a few days ago, when buttons on certain sheets stopped working. Upon inspection of the code I noticed extra sheets were created and the code of the original sheets was moved to the new sheets, also the name of the new sheet was changed (Sheet1 is now Sheet11). Not sure if something in my code would cause this or if this is a new Microsoft glitch. Is anybody else experiencing similar issues or have any clue what would cause this?
You need to attach the problem workbook with the code
Close ‘only’ the VBA Editor and re-open it using Alt + F11 Key
See if the issues is correct or not.
If this issue persists:
Save the Workbook
Close the Workbook
Re-open open the workbook
Check in the VBA Editor if things are corrected or not
Maybe a workbook re-name failed and not updated in VBA Editor
If the issues also persists:
Make a copy of the data of that sheet and paste on a new sheet. This will be same for any codes, remember to copy to the same places
Re-name that problematic sheet as …. OLD and rename the new sheet as old one was
swicked18 most probably issue due to conflict with 2 or more workbooks opened where similar macros applied.
You've 2 options
1. To have opened only one file with these macro package
2. Rename macros and worksheet name too