We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question
0

What might have caused macros to stop working.

asked 2021-04-18 01:51:02 +0200

gary_sitler@ameritech.net gravatar image

updated 2021-05-17 23:10:41 +0200

Alex Kemp gravatar image

Calls to existing macros seem to produce no action at all. I edited some macro to start with a MsgBox to just announce that the macro had been called. Also, whenever I click the "Modules" icon on the menu bar of the Edit macros dialog, it inevitably causes LibreOffice to crash. This began shortly after I attempted to install XrayTool.

edit retag flag offensive close merge delete

Comments

Hello,

You have not presented your OS or LO version and where did you get this version from. I mention as I have another post with a similar problem with the MsgBox. As for XRay it is still uncertain. Post is -> Base Form macro not responding.. Now I have no problem but I use MRI.

Have you removed XRay and possibly reset your user profile -> LibreOffice user profile

Ratslinger gravatar imageRatslinger ( 2021-04-18 02:46:06 +0200 )edit

gary_sitler@ameritech.net gravatar image gary_sitler@ameritech.net 3 ●2 ●3 ●6

updated 42 hours ago

Sorry, my OS is windows 10 home version 2004. My LibreOffice version is 7.0.5.2 (x64). I think I have removed the XrayTool from the Macro libraries. I had to use the Removing_Xray macro to do so. I also tried "repairing" my installation of OfficeLibre. I backed up and deleted the user profile as suggested. Now I get the error message "The driver class 'com.mysql.jdbc.Driver' could not be loaded."

gary_sitler@ameritech.net gravatar imagegary_sitler@ameritech.net ( 2021-04-19 23:47:44 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2021-04-18 05:20:00 +0200

gary_sitler@ameritech.net gravatar image

updated 2021-04-19 23:52:05 +0200

Sorry, my OS is windows 10 home version 2004. My LibreOffice version is 7.0.5.2 (x64). I think I have removed the XrayTool from the Macro libraries. I had to use the Removing_Xray macro to do so. I also tried "repairing" my installation of LibreOffice. I backed up and deleted the user profile as suggested. Now I get the error message "The driver class 'com.mysql.jdbc.Driver' could not be loaded."

edit flag offensive delete link more

Comments

This should be posted as a comment not an answer.

I would guess resetting the user profile would require reloading certain items. It appears you need to set the driver again in LO.

Of course if you have a problem doing that you can go back to the backed up user profile.

My brief testing on both Ubuntu 20.04 & Windows 10 showed Xray was not a problem. Still do not know what is causing the issue.

Ratslinger gravatar imageRatslinger ( 2021-04-18 06:00:18 +0200 )edit

As the other question has now been solved, have you checked you macro security level setting?

From menu Tools->Options. Under LibreOffice-> Security. On right -> Macro Security.

Ratslinger gravatar imageRatslinger ( 2021-04-19 05:41:25 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-04-18 01:51:02 +0200

Seen: 36 times

Last updated: Apr 19