Asi
06-09-2009, 02:39 AM
Hi
I have an excel file that I place on a web site and a lot of users download this file for a specific use.
I heard that a lot of problems occur because the users are not used to Save the file to their own disk before starting to edit it. They Simply press the Open button instead of the Save button when downloading the file.
I want to generate a message that will pop the first time that they open the file. The message will tell them "Please save the file to you own PC first and only then open it for edit".
However:
1- I don't want them to get this message every time they open the file.
2- I thought of inserting a dummy value in a specific cell when first opening the file just to indicate to myself that the file has already been opened once so the message will pop only in the 1st opening. The next opening will see this value and message will not pop. But I need to save the file for them in order to place this indication for the next opening.
Any other ideas how to overcome this problem ??
Thanks
Asi
I have an excel file that I place on a web site and a lot of users download this file for a specific use.
I heard that a lot of problems occur because the users are not used to Save the file to their own disk before starting to edit it. They Simply press the Open button instead of the Save button when downloading the file.
I want to generate a message that will pop the first time that they open the file. The message will tell them "Please save the file to you own PC first and only then open it for edit".
However:
1- I don't want them to get this message every time they open the file.
2- I thought of inserting a dummy value in a specific cell when first opening the file just to indicate to myself that the file has already been opened once so the message will pop only in the 1st opening. The next opening will see this value and message will not pop. But I need to save the file for them in order to place this indication for the next opening.
Any other ideas how to overcome this problem ??
Thanks
Asi