insert who accesses in the workbook

Hello everyone.
In the attached workbook there are macros in thisworkbook:

Please Login or Register  to view this content.

and in:

Please Login or Register  to view this content.

which are used to enter in the "ACCESSI" sheet whoever accesses the workbook.
Also in this workbook there is a macro:

Please Login or Register  to view this content.

to authorize the use of the workbook to certain users who are in the sheet "utenti_errori" column E

There is a problem:

if changes are made and at closing I say "do not save" these changes remain.
Help to correct?
I hope I have explained.
xam

ignore - misread the issue

I badly explained myself?
Sorry for my English

Hello on the net I found

Please Login or Register  to view this content.

and in the sheet "AVVISI"

Please Login or Register  to view this content.

work well.

Now how to insert the exact variable here?

string1 = ThisWorkbook.BuiltinDocumentProperties("content status").Value

long? variant? string.......

Ops not work the modification the post# 4

Basically what I ask is that if changes are made or not to the workbook, whoever makes the changes must be entered

I'm lost as to some of the logic, but the attached has been chopped around a little more and rather than trying to handle everything in the Before_Close event the code has been split out so the Before_Save event is used to determine if the user can save or not.

If the user is authorised to save then it just saves and will prompt to backup immediately after (I've not looked at that, and it may not be the best place for it).

If the user is not authorised to save then the (Italian) 'You are not authorised...' message box will be displayed, the workbook Saved Flag is set to True to prevent other prompts before the next change and the procedure exits.

In the Before_Close event, it again checks and if the user is not authorised it will prompt "Edits will not be saved..." and gives a choice to continue to close or keep the workbook open (in case they might need to copy changes, or whatever).

I'm not saying this is the answer to your question but it is probably a better place to start from. To be honest, the best way to handle this would be to manipulate the ribbon and disable the Save options if the user is not authorised to save - this would greatly simplify things.

Hi cytop,
what I'm looking for is this

Basically what I ask is that if changes are made or not to the workbook, whoever makes the changes must be entered

"...if changes are made or not to the workbook, whoever makes the changes must be entered..."

I'm sorry. I'm confused but this is not what you posted in your first thread. Probably best if I leave it for someone else with a new perspective on this.

Thanks the same cytop.

The change is that I ask is in the post #6
I hope I have explained

Hello,
is it possible to save only 1 sheet?
So it doesn't work:

Sheets("info").Save