Thread: Hiding VBA code
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
David Wooddall-Gainey[_2_] David Wooddall-Gainey[_2_] is offline
external usenet poster
 
Posts: 1
Default 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



.