Page 1 of 1

HYP Top-up spreadsheet - enabling macros

Posted: July 5th, 2021, 2:16 pm
by hassettp
Hi
My version of the HYP Top-up spreadsheet has been deleted by AVG anti-virus.

I'm using Windows 10 and Excel 2016. I've downloaded version 11 HYP Top-up spreadsheet, installed it and, as instructed in Appendix 1 of the user guide, I've changed the the Macro Settings in Trust Centre to:
Disable VBA macros with notification

The other Macro settings enabled are:
Enable Excel 4.0 macros with VBA macros are enabled
Trust access to the VBA project object model

When I load the spreadsheet, I'm not getting the Security Warning. Click on “Enable Content” to enable the macros.

None of the macros will run. There are no error messages.

I've also tried changing the Macros Settings to Enable VBA macros, but the macros will not run.

Any suggestions on how to get the macros to run or an alternative solution? I only use the HYP Top-up spreadsheet to download share prices and Forecast Yields.

Re: HYP Top-up spreadsheet - enabling macros

Posted: July 5th, 2021, 3:24 pm
by ReformedCharacter
hassettp wrote:Hi
My version of the HYP Top-up spreadsheet has been deleted by AVG anti-virus.

I'm using Windows 10 and Excel 2016. I've downloaded version 11 HYP Top-up spreadsheet, installed it and, as instructed in Appendix 1 of the user guide, I've changed the the Macro Settings in Trust Centre to:
Disable VBA macros with notification

The other Macro settings enabled are:
Enable Excel 4.0 macros with VBA macros are enabled
Trust access to the VBA project object model

When I load the spreadsheet, I'm not getting the Security Warning. Click on “Enable Content” to enable the macros.

None of the macros will run. There are no error messages.

I've also tried changing the Macros Settings to Enable VBA macros, but the macros will not run.

Any suggestions on how to get the macros to run or an alternative solution? I only use the HYP Top-up spreadsheet to download share prices and Forecast Yields.
Try:

- Start or restart Excel
- Options > Trust Center > Trust Center Settings > Trusted Documents
- Click 'Clear all Documents so that they are no longer trusted'

RC

Re: HYP Top-up spreadsheet - enabling macros

Posted: July 5th, 2021, 8:30 pm
by kiloran
hassettp wrote:Hi
My version of the HYP Top-up spreadsheet has been deleted by AVG anti-virus.
It does look like Avast and AVG have recently taken a dislike to HYPTUSS, which I am sure is a false positive in the antivirus software.

Have a look at this thread: https://www.lemonfool.co.uk/viewtopic.php?f=27&t=29945

--kiloran