Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding VBA code
I have a subroutine to automate update functions. Several
users need to run the code, so it is assigned to a keyboard shortcut. The sheets are protected. I unprotect in the code and then turn protection back on. Can I hide the vba code from my users, so they cannot see the protection password? TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding VBA code
HI David, Open up your VBA and from the Menu select Tools VBA Project
Properyies Chselect the Protection Tab and Check the box marked "Lock Project for Viewing. Enter and confirm a password and your away. Regards Fred "David Wooddall-Gainey" wrote in message ... I have a subroutine to automate update functions. Several users need to run the code, so it is assigned to a keyboard shortcut. The sheets are protected. I unprotect in the code and then turn protection back on. Can I hide the vba code from my users, so they cannot see the protection password? TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding VBA code
David,
Go into the VBE. Select the Tools menu and VBAProjectProperties. Protect with a password (don't forget this word). Save. Once the workbook is closed and reopened, you can only get to the code if you have the password. Do remember that power users may be able to "crack" your password. Excel is not known to be that secure. But VBA passwords are a little harder to crack. -- sb "David Wooddall-Gainey" wrote in message ... I have a subroutine to automate update functions. Several users need to run the code, so it is assigned to a keyboard shortcut. The sheets are protected. I unprotect in the code and then turn protection back on. Can I hide the vba code from my users, so they cannot see the protection password? TIA |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding VBA code
Thanks!
-----Original Message----- HI David, Open up your VBA and from the Menu select Tools VBA Project Properyies Chselect the Protection Tab and Check the box marked "Lock Project for Viewing. Enter and confirm a password and your away. Regards Fred "David Wooddall-Gainey" wrote in message ... I have a subroutine to automate update functions. Several users need to run the code, so it is assigned to a keyboard shortcut. The sheets are protected. I unprotect in the code and then turn protection back on. Can I hide the vba code from my users, so they cannot see the protection password? TIA . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding VBA code
Ur welcome!
-- sb "David Wooddall-Gainey" wrote in message ... Thx -----Original Message----- David, Go into the VBE. Select the Tools menu and VBAProjectProperties. Protect with a password (don't forget this word). Save. Once the workbook is closed and reopened, you can only get to the code if you have the password. Do remember that power users may be able to "crack" your password. Excel is not known to be that secure. But VBA passwords are a little harder to crack. -- sb "David Wooddall-Gainey" wrote in message ... I have a subroutine to automate update functions. Several users need to run the code, so it is assigned to a keyboard shortcut. The sheets are protected. I unprotect in the code and then turn protection back on. Can I hide the vba code from my users, so they cannot see the protection password? TIA . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding VB Code | Excel Discussion (Misc queries) | |||
Hiding VB Code | Excel Discussion (Misc queries) | |||
How to code Macro for hiding rows | Excel Worksheet Functions | |||
Hiding Code | Excel Discussion (Misc queries) | |||
hiding vba code | Excel Programming |