Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to hide the VBA function or subroutine in excell
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to hide the VBA function or subroutine in excell
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 ** "Hoang Yen" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to hide the VBA function or subroutine in excell
Yes. Point the pointer at Module and right click. select
VBA property. here you can set the password to hide the code. -----Original Message----- 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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Call a subroutine using variable subroutine name | Excel Discussion (Misc queries) | |||
excell hide feature | Excel Discussion (Misc queries) | |||
How can i hide comments given in Excell sheet | Excel Discussion (Misc queries) | |||
Function Calling Subroutine | Excel Programming | |||
how to make a link to a function or subroutine... | Excel Programming |