View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default Setting an Open-file password

Hi Terry

no code needed, save the file using file save as ... choose tools in the
dialog box toolbar, general options - and you can then set a password to
open and /or a password to modify.


--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Terry" wrote in message
...
Hi All,

Can anyone assist me in the code I need to write to password protect a
file
so that the user is prompted for a password when attempting to open the
file.

Kind Regards,

Terry