Disable cell in excel spreadsheet 07
206 views
Skip to first unread message
kparag11
Jun 23, 2009, 2:19:38 AM6/23/09
to Spreadsheet::WriteExcel
Dear all,
Is there any way we can disable cell of excel 2007
spreadsheet so that user can only see the changes and cannot write it
in the cell ?
Is there any way we can disable cell of excel 2007
spreadsheet so that user can only see the changes and cannot write it
in the cell ?
jmcnamara
Jul 1, 2009, 1:43:46 PM7/1/09
to Spreadsheet::WriteExcel
You can achieve this effect by locking the cell via the cell "locked"
format and setting worksheet protection on via the "protect()" method.
See the following section of the docs:
http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel/lib/Spreadsheet/WriteExcel.pm#set_locked()
And this example in the distro:
http://cpansearch.perl.org/src/JMCNAMARA/Spreadsheet-WriteExcel-2.25/examples/protection.pl
John.
--
Reply all
Reply to author
Forward
0 new messages