I think that the ability to share a workbook is currently out width the scope of Spreadsheet::WriteExcel. If you can open excel and activate this feature, record it as a macro then convert the macro then see Re: Excel VB Controls for information how to convert VBA to Perl, since you're using Win32::OLE already.

Martin