View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Philip Philip is offline
external usenet poster
 
Posts: 156
Default 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?