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.
HYP Top-up spreadsheet - enabling macros
-
- Posts: 9
- Joined: December 18th, 2016, 11:02 am
-
- Lemon Quarter
- Posts: 2743
- Joined: November 4th, 2016, 11:12 am
Re: HYP Top-up spreadsheet - enabling macros
Try: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.
- Start or restart Excel
- Options > Trust Center > Trust Center Settings > Trusted Documents
- Click 'Clear all Documents so that they are no longer trusted'
RC
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: HYP Top-up spreadsheet - enabling macros
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.hassettp wrote:Hi
My version of the HYP Top-up spreadsheet has been deleted by AVG anti-virus.
Have a look at this thread: https://www.lemonfool.co.uk/viewtopic.php?f=27&t=29945
--kiloran