Macro on Share Protection

  • Thread starter Thread starter Steven Chan
  • Start date Start date
S

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.
 
What error?

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