stuartgb100
07-01-2015, 10:38 AM
Hi,
I need to delete the Workbook_Open Event code from a workbook before saving.
I believe this can be done as follows:
Tools>Macro>Security - Trusted Publishers and check Trust access to Visual Basic Editor before running the code.
So, I would have to go to every users machine and set this manually ?
What happens if they take work home and try the file on a home machine ?
From the VBA point of view, I understand that many anti-virus programs look for any activity where a reference to the
VBProject object is made.
Could this be an additional issue ?
Many thanks.
I need to delete the Workbook_Open Event code from a workbook before saving.
I believe this can be done as follows:
Tools>Macro>Security - Trusted Publishers and check Trust access to Visual Basic Editor before running the code.
So, I would have to go to every users machine and set this manually ?
What happens if they take work home and try the file on a home machine ?
From the VBA point of view, I understand that many anti-virus programs look for any activity where a reference to the
VBProject object is made.
Could this be an additional issue ?
Many thanks.