How do I hide an Excel module or macro from other users

  • Thread starter Thread starter Guest
  • Start date Start date
Hi Illuminator,

In the VBE:

Tools | VBAProject Properties | Select Protection tab
| Check Lock project for viewing | Furnish & confirm password | OK

Whilst this will deny casual access to your code, the protection afforded by
Excel may readily be removed by anyone with the ability to Google.
 
Hi Illuminator,

If the project has been named, say "MyProject", VBAProject properties would
be: MyProject Properties.
 
To hide VBA code, insert the word Private before a sub e.g.

Private Sub Testmacro ()
code....
End Sub


Rob
 
Dear,
when we lock by using the mentioned method, it generated
another 2 files, atpvbaen.xls (ATPVBAEN.XLA) and funcres
(FUNCRES.XLA). Do you have any ideal of them?
Regards
 
These two files have nothing to do with locking your project. They are
associated with the analysis toolpak and analysis toolpak - vba which are
shipped with excel and enabled by going into Tools=>Addins and selecting
them (which it appears you have done).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to call module function or sub from the Add In? 3
When something in module is shown as a macro 3
Option Private Module (for Object Modules) 5
Programatically changing the macro content. 1
Reference Errors with Distribution of excel sheets with macros 1
How do i password protect my VB Code from users 2
Protect Macro 3
Copying macro from word to excel 8

Back
Top