Save Excel 2007 workbook using vba

[vjs2445]

Hello,

I have code written in Workbook_BeforeSave which doesn't allow to save the workbook.

As a developer How do I save the macro enabled workbook?

I used to do that in Excel 2003 by opening in disable macros but how this is possible in Excel 2007.

Regards,

 

[VoG]

In the VBE press CTRL + G to open the Immediate Window and type in

Application.EnableEvents=False

and press Enter, then save the workbook.

Set events back to True afterwards.

 

[vjs2445]

VoG,

That worked like a charm.

That was neat little trick.

Regards,