When I try to edit any cell, it does not prompt for password, but there is a popup that says something like "this worksheet is protected, you have to unprotect it to edit...". Maybe it depends on version of Excel?
For my copy of MS Excel 2010 (32-bit) on Windows 7 (64-bit), it works fine. Under this version, to unprotect it, click on "Review" and then click on "Unprotect worksheet". Then it prompts for a password.
So is there any way in perl that I can password protect the excel file? I don't want to use the zip password protect either.
So what I am trying to achieve is password protect a excel file that is created using Spreadsheet::WriteExcel. This code is written in unix platform but posted the file in windows.