Is there a way to hide the VBA function or subroutine in excell

H

Hoang Yen

I create functions to be used in excell spreadsheet. But
need to hide these function so the user can not view the
code and/or alter the code. Is there a way to do this?
 
P

Paul B

Hoang, To protect the VBA project, from your workbook right-click the
workbook's icon and pick View Code. This icon is to the left of the "File"
menu this will open the VBA editor, in the left hand window right click on
your workbook name and select VBA project properties, protection, check lock
project for viewing and set a password. Press Alt and Q to close this window
and go back to your workbook and save and close the file.
This password can be hacked with third party software, but will keep most
people out.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
A

axanshi

Yes. Point the pointer at Module and right click. select
VBA property. here you can set the password to hide the
code.
 
Top