Remove ads

Introducing the LemonFools Personal Finance Calculators

Adding Shares to HYPTUS

Discussions regarding financial software
floyd3592
Posts: 29
Joined: November 4th, 2017, 5:13 pm
Has thanked: 10 times
Been thanked: 3 times

Adding Shares to HYPTUS

#172782

Postby floyd3592 » October 10th, 2018, 12:34 pm

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

Breelander
Lemon Quarter
Posts: 2155
Joined: November 4th, 2016, 9:42 pm
Has thanked: 271 times
Been thanked: 488 times

Re: Adding Shares to HYPTUS

#172787

Postby Breelander » October 10th, 2018, 12:44 pm

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.

floyd3592
Posts: 29
Joined: November 4th, 2017, 5:13 pm
Has thanked: 10 times
Been thanked: 3 times

Re: Adding Shares to HYPTUS

#172797

Postby floyd3592 » October 10th, 2018, 1:28 pm

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

Breelander
Lemon Quarter
Posts: 2155
Joined: November 4th, 2016, 9:42 pm
Has thanked: 271 times
Been thanked: 488 times

Re: Adding Shares to HYPTUS

#172806

Postby Breelander » October 10th, 2018, 2:17 pm

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

floyd3592
Posts: 29
Joined: November 4th, 2017, 5:13 pm
Has thanked: 10 times
Been thanked: 3 times

Re: Adding Shares to HYPTUS

#172810

Postby floyd3592 » October 10th, 2018, 2:49 pm

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


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 2 guests