Thread: Hiding VBA code
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frederick Frederick is offline
external usenet poster
 
Posts: 6
Default 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