Macro on Share Protection
 

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.

Macro on Share Protection
 

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 wrote:

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

Macro on Share Protection
 

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

Steven

"Dave Peterson" wrote:

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 wrote:

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