View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Kilmer Bob Kilmer is offline
external usenet poster
 
Posts: 280
Default how to make subs/procs can only be called from within the workbook they belong to?

Class modules whose Instancing property is set to Private (the default) are
also invisible outside the workbook.

--
Bob Kilmer


"Arnoud Oortwijk" wrote in message
...
Hi,

Can someone tell me if (and how) I can prevent subs and procedures in a
workbook to be called from outside that workbook?

Any help will be greatly appreciated.
--
HTH

Arnoud