Bug 134361 - activeworkbook.followhyperlink in macro throws error
Summary: activeworkbook.followhyperlink in macro throws error
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
Reported: 2020-06-28 13:28 UTC by johnks
Modified: 2023-02-26 17:10 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

error screenshot (23.32 KB, image/png)
2020-06-28 13:29 UTC, johnks
macro errors files (833.91 KB, application/zip)
2020-07-10 17:57 UTC, johnks

Note You need to log in before you can comment on or make changes to this bug.
Description johnks 2020-06-28 13:28:45 UTC
i have excel macro enabled workbooks that have activeworkbook.followhyperlink vba command and my libreoffice calc throws 

BASIC syntax error: 
Unexpected symbol:address


this link describes microsoft method of using this vba but LO does not work well with this.

Steps to Reproduce:
open a file containing vba with a button

Rem Attribute VBA_ModuleType=VBAFormModule
Option VBASupport 1
Private Sub CommandButton1_Click()
ActiveWorkbook.FollowHyperlink _
End Sub

Actual Results:
BASIC syntax error.
Unexpected symbol: Address.

Expected Results:
link in the button should work. currently the only way to work on the file containing this vba is to remove the line and then run

Reproducible: Always

User Profile Reset: No

Additional Info:
Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: kf5; 
Locale: en-IN (en_IN.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 johnks 2020-06-28 13:29:09 UTC
Created attachment 162476 [details]
error screenshot
Comment 2 Xisco Faulí 2020-07-10 16:55:15 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 3 johnks 2020-07-10 17:57:23 UTC
Created attachment 162893 [details]
macro errors files

this zip contains some macro enabled files which have the current buggy activeworkbook hyperlink error and some more errors
Comment 4 Buovjaga 2020-11-09 06:48:46 UTC
Confirmed with the files. They give a warning about exceeding the max. number of columns, but I guess it does not affect this.

Arch Linux 64-bit
Build ID: c9b320c32aceab7e22d381b688e7b44030e01c2d
CPU threads: 8; OS: Linux 5.9; UI render: default; VCL: kf5
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 8 November 2020
Comment 5 QA Administrators 2022-11-10 04:02:49 UTC Comment hidden (obsolete)
Comment 6 johnks 2022-11-10 05:07:28 UTC
confirmed in

Version: / LibreOffice Community
Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-IN (en_IN); UI: en-US
Calc: threaded

there is now no "exceeded columns" warning so that is a win
Comment 7 johnks 2023-02-26 17:10:44 UTC
confirmed in 
Version: (X86_64) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 4; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: en-IN (en_IN); UI: en-US
Calc: threaded