Help with shared worksheet protection....

Carol D'Amato
New Contributor

Hi all!  Hoping I can get help with this!


We have a sheet a bunch of us here share that calculates estimated shipping costs.  Every time someone uses it, it saves the last weight and dimension entry someone made to the sheet.  How can we all use it, enter our info and have it auto clear for the next person to use once it is re-opened??  Is there a way It can LOCK the original version storing JUST the formulas but not the updates people make to the sheet??  Hope this makes sense!!  Thanks in advance!!

5 Replies

Hi Carol,


You could save the file as Read only  via File > Save As > Tools > General Options >







You could also add a a password to modify

Thank you for responding!! If we do "read only" or password modify, will people still be able to use the sheet.  It is being used for shipping calculations so there are columns where whoever needs a shipping quote can put in the weights and dimensions of the shipment and then the other columns have formulas that will generate an approx. shipping quote.  Will people still be able to do this?  We just want to ensure that when the spreadsheet is closed, when the next person opens, the prior user's weights and dims do not get saved causing potential overlap and thus miscalculation if they don't see the columns were already populated.  Thanks again :)

I would be inclined to have it readonly. (File, Info, Protect Workbook, Always Open Read-Only). People can choose to save it but they have to consciously decide to do so. 


If that won't work you could use vba code that clears the cells that people fill in and then save the workbook again every time someone closes the workbook. 


Something like this:


Private Sub Workbook_BeforeClose(Cancel As Boolean)
End Sub


That way you know the relevant cells are always empty whenever the next person opens the workbook.

Hi Carol
Yes, read-only allows users to use the file but not save it

Thanks so much :)

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies