I'm distributing a spreadsheet with macros and password protection that uses the "AllowFormattingColumns:= True" parameter to allow the user to resize columns, hide columns and freeze panes on a protected worksheet. On Excel 2010, which I use for development, all of these features work. However, on Excel 2007, the Freeze Panes button on the View menu is greyed out and doesn't work. How can I allow freeze panes in Excel 2007 on a protected spreadsheet?