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
.
|