security/protecting an excel program
 

:confused: Does anyone know how to password protect an Excel progra
when other people are accessing the program on a network. Ideally,
would like to make the program force people to enter a password whe
initially opening the program. Secondly, I would like to add anothe
password protection (different password) when people are trying t
access the VB coding to the program. Does anyone have any clues?
would appreciate it a lot. Thanks guys :)


Gunma

--
gunma
-----------------------------------------------------------------------
gunman's Profile: http://www.excelforum.com/member.php...fo&userid=2399
View this thread: http://www.excelforum.com/showthread.php?threadid=47358

security/protecting an excel program
 

Hi Gunman

You can protect you workbook with a password
FileSaveAs on the tools menu see General options

You can protect your code with apassword also
Alr-F11 to go to the editor
See ToolsVBA project properties


--
Regards Ron de Bruin
http://www.rondebruin.nl


"gunman" wrote in message
...

:confused: Does anyone know how to password protect an Excel program
when other people are accessing the program on a network. Ideally, I
would like to make the program force people to enter a password when
initially opening the program. Secondly, I would like to add another
password protection (different password) when people are trying to
access the VB coding to the program. Does anyone have any clues? I
would appreciate it a lot. Thanks guys :)


Gunman


--
gunman
------------------------------------------------------------------------
gunman's Profile: http://www.excelforum.com/member.php...o&userid=23994
View this thread: http://www.excelforum.com/showthread...hreadid=473580