workbook openings macro control

[john_cash]

Hi to all.
The workbook attached to the INFO sheet contains the accesses of those who open the workbook
Is this change possible?
Every time the workbook is opened and then closed, the data in the info sheet must be saved without requesting a save at closing.
Only if the other sheets are modified must the saved warning be displayed at closure.
I hope I explained myself
john

[Greg M]

Hi there,

Take a look at the attached version of your workbook and see if it does what you need.

It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your own requirements.


The ThisWorkbook.Saved = bSaved statement will cause the "Do you want to save . . ." prompt to be displayed when appropriate, but in reality it is not required because the workbook will have been saved anyway! It may be useful to leave it in place so that Users do not think that the workbook has been closed without giving them the opportunity to save their work.

Hope this helps - please let me know how you get on.

Spero di averti aiutato

Regards,

Greg M

[john_cash]

Hi greg.
your macro works like mine.
The modification that I ask, if possible, is that if the sheet is modified and I choose no in the closing notice,
it must not be changed.
Now it is so, now at the opening I find the modified workbook
john

[Greg M]

Hi again,

Thanks for your feedback.

You have two options:

(a) allow workbook changes not to be saved unless the User agrees;

(b) record the "FINE SESSIONE" time when the workbook is closed.

You cannot record the "FINE SESSIONE" time without saving all other changes also.

Regards,

Greg M

[john_cash]

You cannot record the "FINE SESSIONE" time without saving all other changes also.

that's what I was looking for but it's not possible.
Anyway thank you anyway Greg M
A greeting
john