http://qs321.pair.com?node_id=1159857


in reply to Perl script to disable cut copy % paste in an xlsx worksheet

VBA is the only way to prevent Copy/Paste on Data Validation cells

To get this from Perl you'll need to add VBA to your file: 

    my $workbook  = Excel::Writer::XLSX->new( 'file.xlsm' );

    $workbook->add_vba_project( './vbaProject.bin' );

[download]

In Section Seekers of Perl Wisdom