I have a macro that hides sheets (bar one) saves the result then
returns the sheets to view.... the user sees only a blib and is
returned to the same point prior to save. The problem is if the user
uses Ctrl. "S" or Excels save...
I can use the "before-save" in workbooks but can't figure out how
after save is automatically triggered how to return to the same sheet.
The best I can accomplish is to have a button on the Sheet left
visible after save that drives the sheets back open and back to the
sheet prior to save.
The solution may be simple but... "can't see the wood for the trees
??!!"
Any help appreciated