View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 24
Default Save as Read-Only

FileFormat:=xlNormal, Password:="test", ReadOnlyRecommended:=True,
CreateBackup:=False


Corey....


"hurlbut777" wrote in message
...
I have a folder that contains numerous excel files. What I would like to
do
is loop through the folder and make all the files read-only with the
read-only password being "test". I can create the loop code, I'm just
having
trouble with the read-only piece. Can one with more knowledge than me
please
assist?