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