in reply to Re: Password protection creating an Excel spreadsheet
in thread Password protection creating an Excel spreadsheet

Hi Martin, I have created a excel sheet which contains 6 worksheets, 1: Contains data 2 - 6: Charts created using add_chart Here I dodnt have a handle for chart worksheet. How to protect all the 6 sheets ?
  • Comment on Re^2: Password protection creating an Excel spreadsheet

Replies are listed 'Best First'.
Re^3: Password protection creating an Excel spreadsheet
by Anonymous Monk on Apr 28, 2011 at 06:27 UTC
Re^3: Password protection creating an Excel spreadsheet
by davies (Monsignor) on Apr 28, 2011 at 10:47 UTC

    Since this thread has been resurrected, it's probably worth putting in a pointer to a node I wrote in a similar, later thread: Re^4: Password Protect Excel File. Excel's internal protection is like a knee high fence. It's no more than a polite warning to the law abiding. Files can be properly secured so that they cannot be opened without the password, but sheet and project level protection is extremely weak and can be bypassed trivially. The link provided does not cover project level protection, but JFGI.

    Regards,

    John Davies