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.