save without changes vba

[wayneg]

I know this has been asked before, but i cant find an answer for the problem.

I have a spreadsheet that multiple users use and i want to display 1 worksheet that asks the user to "enable the macro". when they do, that page hides and 3 others are shown. This part works ok
when they save the spreadsheet, it saves as normal.

what i want to do is when the user closes the spreadsheet is to rehide the 3 opened worksheets and unhides the original worksheet that asks to "enable the macro". this works fine also when the user presses save when closing. however if they dont want to save when closing, then the worksheet states doesnt change to my desired states and so when the next person opens the sheet, they are not prompted to "enable the macro" due to the 3 worksheets are open and not the single sheet.

i use this vba for the close

Please Login or Register  to view this content.

and use this vba for the exit

Please Login or Register  to view this content.

if they chose yes, save my changes when they close it all works good, but if they choose No then im a little screwed.


is there a vba that if they choose no to the changes that removes all the changes they did make (since last save) and save it anyway?

[ByteMarks]

is there a vba that if they choose no to the changes that removes all the changes they did make (since last save) and save it anyway?

To me, that sounds tricky especially as the undo stack is reset when using macros.

An alternative could be to protect the "main" file so that it needs a password to open it. Then use another "opener" file which opens the "main" file with the password and closes itself.
That way the "main" file can't be opened unless it's via the "opener" file, which needs macros enabled.

[MSDols]

Hi,
you can do it with a macro.
But there is a risk that "someone" will save the file in "Design Mode", or in "error" state.
It is up to you to weigh the risks.

Principle with internal macro:
before each saving, all sheets except "Landing Page" are hidden.
After saving, the sheets return to their original state.
m.s.

Please Login or Register  to view this content.