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

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

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

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


.

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


.