We are able to protect sheets from accidental or deliberate contamination but I don’t think we can hide our macros from at least being read as you can with MS Excel. If I’m right then what is the point of passwords if all a person has to do is look it up on your macro. There are times when you want to change values in a cell that is protected with a macro as well as you just don’t want anyone being able to tamper with the macros. Is there a way to completely hide or protect your macros in Libre Calc?
Archive your Macros in a Library unlike the Standard, in this created one, you can enter a password.
Access the Macro Organizer to enter a password.
1 Like
Thank you for this. It really is quite simple. However transferring macros from one library to another is not so simple. Can you give me some hints as to how to force the program to use the macros in the new library instead of the old library? I do understand that I must make some changes to such things as to which macros are run with certain actions such as key strokes but I’m having prblems with a particular macro which is triggered when a cell value is changed.
Hi @OldJack, keyboard shortcuts only worked on your machine, they are not loaded into the file.
As for moving Macros between Libraries, just cut from the Old and paste into the New, the macros are recognized in your new Library.
Regarding the change of a cell that triggers the Macro, this information is linked to Spreadsheet Events.
Ola @OldJack, atalhos de teclado, só funcionaram em sua maquina, não são carregados no arquivo.
Quanto a mover Macros entre Bibliotecas, é so recortar da Velha e colar na Nova, as macros são econhecidas em sua nova Biblioteca.
Sobre a alteração de uma célula que aciona a Macro, esta informação fica ligada a Eventos de planilha.
menu:Tools>Macros>Organize>Basic…
Button [Organizer…]
On tab “Libraries” you can create libraries.
On the “Modules” tab you can drag&drop modules from one library to another. Ctrl+Drop creates a copy.
Thanks again for your reply. The problem seems to be that I can only link one macro to each event. As I wish to link a particular macro to the Open Document Event, I have tried to link the SheetChange macro to the Activate Document Event but it doesn’t work.And if I reverse these two macros it doesn’t either. You mention “Spreadsheet Events” but there doesn’t seem to be such a thing. Can I link more than two macros to a single event. I need something like a Activate Sheet event. 