Macro on Share Protection

[Steven Chan]

I recorded a macro as follows to share a file with password protection : -
ActiveWorkbook.ProtectSharing Filename:="C:\Users\Public\VwPL RDD RS.xls", _
Password:="xxcc", WriteResPassword:="vvbb", FileFormat:=xlExcel8
The recording went thru fine.
When I play it back it shows an error.

Can anyone help. Tq.

 

[Dave Peterson]

What error?

I tried the code in xl2003 and after I removed the fileformat parm, it worked
fine. (You must be using xl2007????)

 

[Steven Chan]

Thanks Dave. Yes, using 2007.I have got it working now with some tuning.

Steven