View Single Post
  #1 (permalink)  
Old September 4th, 2003, 08:58 AM
james gold james gold is offline
Authorized User
Join Date: Sep 2003
Location: , , .
Posts: 25
Thanks: 0
Thanked 1 Time in 1 Post
Default How to hide VBA code


I need to create a spreadsheet that contains a set of special functions for manipulating data. Obviously this can be done with VBA. However, it is vital that users of the spreadsheet are unable to see or edit this code. What options do I have? This is a new area to me, so I can envisage a couple of possibilities:

a) Write a plug-in for Excel that adds some new menu options that run the code behind the scenes. The code spits out the results to cells as required.

If this is possible - how do I do it? How straightforward is it to write a plug-in? How is it installed be the user etc. etc?

b) Write some VBA (as normal) but somehow "protect" it so that it can't even be looked at by the user.

I don't know if such a thing is possible - is it? If so, how do I do it?

There may be other options that I don't know about. I am relatively new to Excel, so am not sure what my options are.

Please let me know what I can do - all suggestions gratefully received a.s.a.p.

Many thanks.


Reply With Quote