Maximize protected sheets


#1

Hi,

When I encrypt a workbook based on a template file (usign ExcelDesigner) and save it, the sheets of this newly created file are not maximized when the excel file is opened. And as it is protected, it is not possible to maximize them. Can we change the behaviour? I trie d to play with worksheet.UnFreezePanes() but it don't think it is the the correct way.

Thanks,

Omid.


#2

Hi Omid,

When you protect the workbook, please use ProtectionType.Structure option. Then the file can be maximized.


#3

Thanks Laurence,

As usual, it works:).