By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,701 Members | 1,938 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,701 IT Pros & Developers. It's quick & easy.

how to create an activeX of user form in VBA

P: 1
I have created one application which I want to resuse in anothter applications. I would rather donīt want to allow/share the excel sheet among other users so I want to create a control which could be shared with others.

There is one UserForm which is required to be accessed on worksheet.

any help to create such activeX/.ocx in VBA would be appreciated.

Thanks,
Vishal
Apr 1 '12 #1
Share this Question
Share on Google+
1 Reply


Expert Mod 2.5K+
P: 2,545
VBA cannot be used to create ActiveX controls.

I doubt very much that you can stop users accessing an Excel workbook if this forms part of what you have developed. I cannot envisage any way you could package these in some form of control - even if it could be done at all.

It is possible to protect the code in workbooks (at its simplest by setting a password) but you have not told us enough to advise much more on what may or may not be suitable for your particular needs.

-Stewart
Apr 1 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.