ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Protection - restrict macro exposure to the workbook, VBAProject (https://www.excelbanter.com/excel-programming/348189-protection-restrict-macro-exposure-workbook-vbaproject.html)

JB2005

Protection - restrict macro exposure to the workbook, VBAProject
 
How do you prevent external macros (not held in the workbook VBAProject)
running in a workbook?

i.e. Is it possible to restrict macro exposure to those held in the workbook?


Philip

Protection - restrict macro exposure to the workbook, VBAProject
 
not really,

normally the workbook and all it's objects is exposed to any VBA code that
has access.

So you could protect the workbook to prevent it being opened unless the
password is used.

HTH

Philip

"JB2005" wrote:

How do you prevent external macros (not held in the workbook VBAProject)
running in a workbook?

i.e. Is it possible to restrict macro exposure to those held in the workbook?



All times are GMT +1. The time now is 07:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com