Monday, 26 August 2013

Excel Save Notification for a Shared File

Excel Save Notification for a Shared File

I have a shared file in excel. This is how it was defined in VBA when it
was created:
AccessMode:=xlShared,
ConflictResolution:=Excel.XlSaveConflictResolution.xlLocalSessionChanges
When a user makes a change to the shared file and saves it, I would like
make a program which makes a pop up msg or something to notify all users
immediately that the file has been changed. How is this possible?

No comments:

Post a Comment