Hi,
We use a spreadsheet that contains VBA code/macros. Recently, and particularly with users that are getting new laptops, the spreadsheet opens in Design mode, and doesnt run any VBA code.
If you then click "Exit Design Mode" from the VB toolbar, then following error appears:
"The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros"
Anyone know whats causing this behaviour, and how to fix it?
Thanks in advance.
Chris
We use a spreadsheet that contains VBA code/macros. Recently, and particularly with users that are getting new laptops, the spreadsheet opens in Design mode, and doesnt run any VBA code.
If you then click "Exit Design Mode" from the VB toolbar, then following error appears:
"The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros"
Anyone know whats causing this behaviour, and how to fix it?
Thanks in advance.
Chris