[Solved] Created tabs using VBA and macros - some tabs stop working

[lsaggs]

I have created tabs in the attached file, but my Tuesday, September 23 ADAM ROOM tab stops working every time I assign a macro to it. It works once, then once I've clicked on it, I'm no longer able to use it as a tab. I have to keep reassigning the macro to get it to work. The others seem to be working fine.

Also, when I click the first tab 'Monday, September 22 ADAM ROOM', it will often (but not every time) move to the next column after all of my data.

I'm very new to this, and just learned how to do this through the Youtube video, please help!

 

[shamimarita]

Hello Isaggs,

It sounds like you’ve created tabs (worksheets) using VBA/macros, but some of them stop working or become unresponsive. This is a common issue and can be caused by a few things:

Possible Reasons & Solutions:
Event Macros Disabled: If your tabs rely on worksheet event macros (like Worksheet_Change), make sure events are enabled. Run this in the Immediate Window or a macro:
Application.EnableEvents = True

Macro Scope: If your macro creates new sheets and assigns code, remember that VBA cannot copy code into new sheets automatically. If your buttons or shapes call macros using assigned names (like Button1_Click), these need to exist in a regular module, not inside a worksheet module.

Button Assignments Lost: If you create buttons or shapes with assigned macros, sometimes the assignment doesn’t carry over to new tabs. You may need to re-assign the macro to each button or shape after copying or creating the new sheet.

Corruption or Naming Conflicts: Excel sometimes glitches with too many copied sheets or name conflicts. Try deleting problematic tabs and recreating them from a clean template.

ActiveX vs. Form Controls: If you’re using ActiveX controls, they often don’t copy well between sheets. Form controls are more stable for sheet duplication.