also sprach Andreas Säger <[email protected]> [2015-04-15 17:40 +0200]: > There is a macro under "LibreOffice Macros">Tools>Misc>ProtectSheets > which can be used together with Tools>Customize>Events>"Save Document"
Oh, I didn't even know about all these macros. I'll investigate! Thanks. Unfortunately, ProtectSheets doesn't seem to work on an existing document (while it works fine on a new document). If I assign it to the "Save Document" event, then I get an error about a missing "property or method" Count on the line For i = 0 To oDocSheets.Count-1 Do you have any idea what could be going on here? While I can read this language, I have absolutely no idea about it. When I set a break point on the macro, it's being ignored unless I run the macro directly. And then, the error is a different one, it seems, namely that StarDesktop.CurrentFrame.Controller.Model.Sheets 5 lines above is "out of scope" and (consequently) has no property or method "Sheets". > 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. Oh, I am well aware that spreadsheets are hackery, but the use cases I have (mainly budgeting in non-profits) require a high degree of flexibility. I am not aware of any database that would be suitable for these tasks, and creating one would require *way* more time than scrambling along, especially since the structure of the budget (e.g. for DebConf taking place in a different country every year) varies considerably every year. Sure thing, I want to try to normalise this a bit and then maybe the time for a database approach has come, but for now, spreadsheets with locked cells are as good as it gets. Thanks -- @martinkrafft | http://madduck.net/ | http://two.sentenc.es/ "it is easier to be a lover than a husband for the simple reason that it is more difficult to be witty every day than to say pretty things from time to time." -- honoré de balzac spamtraps: [email protected] -- 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
