Unfortunately i dont know how to hide them but i figure you want to hide
it on a user drive so that when they open a file it can source back to
the "hidden" file and update the file. i know that you can set up a
macro to create the file and save it with a password and you can set
the password to equal what ever you like e.g
Sub Macro1()
Password = "MYPASSWORD"
ChDir "C:\...."
ActiveWorkbook.SaveAs Filename:= _
"C:\...\Book1.xls", FileFormat:= _
xlNormal, Password:="" + password + "", WriteResPassword:="" +
password + "", _
ReadOnlyRecommended:=False, CreateBackup:=False
End Sub


Give that a shot.

If you ever find out how to hide a file with a macro post it please.

Thanks


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=548407