how to make subs/procs can only be called from within the workbook they belong to?
 

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

how to make subs/procs can only be called from within the workbook they belong to?
 

Arnoud,

Put "Option Private Module" at the top of the code module containing the
code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"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

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