How to clear the value of one cell upon opening or closing the workbook. While users are working with the workbook they are free to use the cell unrestricted.
Thanks
How to clear the value of one cell upon opening or closing the workbook. While users are working with the workbook they are free to use the cell unrestricted.
Thanks
Is the file is in sharing?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
PHP Code:
There are multiple users but only one can save at a time. If two people try to use the file at the same time the second perond gets a notice they are read only.
Thanks Sixthsense - nice hearing from you again.
Thanks for the information. Please confirm the Cell Name and Sheet name for giving solution.
Cell name: A1 Sheet name: sheet2
Thanks
Add the below code in ThisWorkbook Code window
The sheet2-A1 cell will be marked as blank at the time of file open. Don't forget to save the file as .xlsm or .xlsb file format to keep the macro.Please Login or Register to view this content.
I'll try it and report back. THANKS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks