Am 15.04.2015 um 14:32 schrieb martin f krafft: > Dear all, > > we've been pretty strict about locking our Calc sheets, turning cell > protection on by default and selectively unlocking those cells that > are meant to be edited. > > Every now and then, some protected cells have to be changed. > Currently, the mode of operation is to unlock the sheet, edit, and > then lock the sheet again, before saving. > > Unfortunately, that second-to-last step is often forgotten, > resulting in us committing a version of a document with unlocked > sheets. > > Is there a better way to approach this? Is there maybe a trick how > to automatically protect all sheets on save, or to just temporarily > unlock them? > > Thanks, >
Hi, There is a macro under "LibreOffice Macros">Tools>Misc>ProtectSheets which can be used together with Tools>Customize>Events>"Save Document" A database with an input form would save you a lot of trouble, but this would require that you forget about spreadsheets and accept a more professional approach. Greetings, Andreas -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
