Macro is not there but still runs
Macro is not there but still runs
I am programming in VBA to change an Excel sheet. After the file closed and autorecovery- Now I am unable to see one of my macros in Module 1, whilst macro's in Module 2 are visible. Whats even stranger is that the(invisible) macro runs. Please help, it took me weeks to program it.
OOo 2.3.X on Ms Windows Other
Re: Macro is not there but still runs
Go to Module1, hit Ctrl+A, Ctrl+C. What's in the clipboard?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Macro is not there but still runs
Ctrl A and Ctrl C does nothing so I assume there is nothing in the clipboard. Any other suggestions?
OOo 2.3.X on Ms Windows Other
- Hagar Delest
- Moderator
- Posts: 32664
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Macro is not there but still runs
Can you upload the file here (see here: How to attach a document here)?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Macro is not there but still runs
Sorry Hagar file is way too big I can only zip it to a 1000 KB and the sharing file is undergoing maintenance
OOo 2.3.X on Ms Windows Other
- Hagar Delest
- Moderator
- Posts: 32664
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Macro is not there but still runs
Even if you remove all the content to keep only the macro modules it's too big?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Macro is not there but still runs
He could also paste his clipboard content for the same purposeHagar de l'Est wrote:Even if you remove all the content to keep only the macro modules it's too big?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
- Hagar Delest
- Moderator
- Posts: 32664
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Macro is not there but still runs
But his clipboard seems to be empty!
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Macro is not there but still runs
Ctrl A and Ctrl C does nothing so I assume there is nothing in the clipboard. Any other suggestions?
Copying does not do anything visible, which is why he assumes that it is unchanged.Hagar de l'Est wrote:But his clipboard seems to be empty!
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
- Hagar Delest
- Moderator
- Posts: 32664
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Macro is not there but still runs
It should at least highlight the code.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10