[Solved] Macro in "Customise..." is not executed (Win10)

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
ambusy
Posts: 5
Joined: Tue Jan 24, 2017 12:41 pm

[Solved] Macro in "Customise..." is not executed (Win10)

Post by ambusy »

I have an application on Win7, where I customise keys to execute a macro. I moved the application to Windows10 and it no longer works.

Solution: the underlying problem was in Tools -> Options -> Security. In Macro Security I changed the level to the lowest security possible, and now it works......
Remains the doubt, why it works while you are in a new document!

original problem description:
I created an example on Win10 that shows what works and what not.
1. I create a new Calc sheet "Untitled 1", still empty:
https://digilander.libero.it/ambusy/i1.jpg
2. I create a simple macro contained in the document "Untitled 1" itself: Sub Main that displays a Msgbox
https://digilander.libero.it/ambusy/i2.jpg
3. I customize the keys, and assign Alt+0 to execute macro Main in Standard Module "Untitled 1":
https://digilander.libero.it/ambusy/i3.jpg
4. I return to the Calc sheet and press Alt+0: message appears
https://digilander.libero.it/ambusy/i4.jpg
5. I close the Calc window, the macro editor window remains open.
https://digilander.libero.it/ambusy/i5.jpg
6. Close the editor too, and reopen the "Untitled 1.ods":
https://digilander.libero.it/ambusy/i6.jpg
7. Verification of customization: macro Main is still assigned to alt+0:
https://digilander.libero.it/ambusy/i7.jpg
8. I press Alt+0 and nothing happens.....................

Did this exercise 3 times with different keys (Alt+0, F4 and Ctrl-I) always the same result, when new it works, when reopened it no longer does. Also a Run Macro does not run. In my Win7 all works well.
OpenOffice 4.1.3 on Windows 7
ambusy
Posts: 5
Joined: Tue Jan 24, 2017 12:41 pm

Re: [SOLVED] Macro in "Customise..." is not executed (Win10)

Post by ambusy »

solved, see above
OpenOffice 4.1.3 on Windows 7
User avatar
Zizi64
Volunteer
Posts: 11363
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: [SOLVED] Macro in "Customise..." is not executed (Win10)

Post by Zizi64 »

In Macro Security I changed the level to the lowest security possible, and now it works......
It is enough to change the security level to Medium. In this case the software will ask you, if you want to launch the macros storaged in the document - or not.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply