I have a workbook that has it's own set of menus and options. They are set in Workbook_Activate(). I would like to have all the menus and options changed back in Workbook_Deactivate().

I have no problem with the menus. In Workbook_Activate() I put a flag in the .Tag property of a CommandBarControl in every visible CommandBar, then in Workbook_Deactivate, I look for the flags and reset the menus.

1) Is there a better way to do the menus?
2) How can I do something similar for the other options (DisplayFormulaBar, MoveAfterReturnDirection, etc) ? I would prefer not to save the options in the workbook, and I don't want to depend on a memory variable.