Page 1 of 1

Adding Shares to HYPTUS

Posted: October 10th, 2018, 12:34 pm
by floyd3592
Hi

i'm having trouble beginning to populate HYPTUS with my shares. How do I add a share? When I open the HYPTUS it informs me that macros are disabled so I think that's the problem but when I go to enable macros I can't choose 'options' from the Tools dropdown as it isn't there!... Can someone give me guidance?

HYP Top-up Version: - b-i-1
Operating System: - macOS 10.14 (Mojave)
open office version: - 4.1.5

Cheers
Floyd

Re: Adding Shares to HYPTUS

Posted: October 10th, 2018, 12:44 pm
by Breelander
floyd3592 wrote:When I open the HYPTUS it informs me that macros are disabled so I think that's the problem...


It is, but you can't change it once you have opened the spreadsheet. You have to set Office to ask you if you want to enable macros at the time you open HYPTUSS.

To set Open Office up so that it does this, just open Office on its own. In 'Tools, Options, Security, Macro Security' set Medium security level. Then you get offered the choice to enable macros when opening the spreadsheet.

Re: Adding Shares to HYPTUS

Posted: October 10th, 2018, 1:28 pm
by floyd3592
Breelander wrote:To set Open Office up so that it does this, just open Office on its own. In 'Tools, Options, Security, Macro Security' set Medium security level. Then you get offered the choice to enable macros when opening the spreadsheet.


Thanks Bree

I tried opening Office on its own but unfortunately I still can't see an 'Options' choice when I click on the Tools dropdown...

Cheers
Floyd

Re: Adding Shares to HYPTUS

Posted: October 10th, 2018, 2:17 pm
by Breelander
floyd3592 wrote:I tried opening Office on its own but unfortunately I still can't see an 'Options' choice when I click on the Tools dropdown...


That's how it's set in the Windows version, but apparently it's different for a Mac...

All application settings are accessed through the desktop Preferences menu, not through any menu in the application itself--or so I'm told.

Desktop > Preferences > OpenOffice > ... is equivalent to (app menu) Tools > Options > ... on Windows & Linux
https://forum.openoffice.org/en/forum/v ... 96#p290272

Re: Adding Shares to HYPTUS

Posted: October 10th, 2018, 2:49 pm
by floyd3592
Breelander wrote:
floyd3592 wrote:I tried opening Office on its own but unfortunately I still can't see an 'Options' choice when I click on the Tools dropdown...


That's how it's set in the Windows version, but apparently it's different for a Mac...

All application settings are accessed through the desktop Preferences menu, not through any menu in the application itself--or so I'm told.

Desktop > Preferences > OpenOffice > ... is equivalent to (app menu) Tools > Options > ... on Windows & Linux
https://forum.openoffice.org/en/forum/v ... 96#p290272


Thanks,

It's sorted now. For the benefit of other Mac users you set the macros level via 'preferences>security>macro security' when Open Office App is opened.

Cheers
Floyd