VBA Creating new sheets and moving code

swicked18 · Mar 20th 2020

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?

**royUK** · Mar 20th 2020

You need to attach the problem workbook with the code

**Jack in the UK** · Mar 20th 2020

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

jiuk

johanzarchu · Mar 20th 2020

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

VBA Creating new sheets and moving code

Participate now!

Share