workbook_beforesave fires but doesn't do anything when triggered by thisworkbook.save

[brokenbiscuits]

Hey guys, it's been a while. I'm having a real headache with some VBA on a workbook. The goal is to autosave every time a specific button is clicked on a userform:

Please Login or Register  to view this content.

When it reaches the activeworkbook.save line at the end, it fires up the workbook_beforesave command. However, even though the code fires, it doesn't DO anything. I can F8 through the code, and it seems to run, but when it gets to a sht.visible=False line, for instance, nothing happens. Same with thisworkbook.save. It just completely ignores what it's reading. When I click 'Save' manually, the code runs perfectly. Any ideas what might be causing the issue? Am I doing something stupid here?

Workbook_beforesave code:

Please Login or Register  to view this content.

[brokenbiscuits]

Just to add, I still haven't discovered why this doesn't work, but I've found a workaround by putting the workbook_beforesave code into a standalone module and then running the module at the end instead of the activeworkbook.save line.