 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2008How to protect some specific module in VBA project?
As we know, we can protect the whole VBA project. but if i want to protect one or two modules in a VBA project. How to do so? thanks! Put them in a separate file ? Tim > As we know, we can protect the whole VBA project. but if i want to protect > one or two modules in a VBA project. How to do so? > thanks! there are some common functions and procedures in my module, and now, i want to protect this module. if i put them in another separate file, can i call the functions and procedures easily and efficiently? i've no idea of this. thanks!! > Put them in a separate file ? > [quoted text clipped - 3 lines] > > one or two modules in a VBA project. How to do so? > > thanks! You could set a reference to your other file (make it an addin) and call procedures directly. Otherwise you maybe able to use Application.Run for your needs. Note you cannot pass objects, arguments are byVal. Functions can return values or an array, but not an object. If need to handle objects, pass names or index's with as much qualification as needs. Regards, Peter T > there are some common functions and procedures in my module, and now, i want > to protect this module. [quoted text clipped - 9 lines] > > > one or two modules in a VBA project. How to do so? > > > thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.