ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   freeze pane option not available (https://www.excelbanter.com/excel-worksheet-functions/252933-freeze-pane-option-not-available.html)

dave f

freeze pane option not available
 
The freeze pane option is not highlighted on my toolbar. Consequently, I
cannot select it for use. As best as I can determine the worksheet is not
procted.

Gord Dibben

freeze pane option not available
 
Worksheet protection will not disallow Freeze Panes.

Could be the workbook protection is enabled.

ToolsProtectionUnprotect workbook.

Or in 2007

Review TabProtect Workbook.


Gord Dibben MS Excel MVP

On Sun, 10 Jan 2010 13:31:01 -0800, dave f <dave
wrote:

The freeze pane option is not highlighted on my toolbar. Consequently, I
cannot select it for use. As best as I can determine the worksheet is not
procted.




All times are GMT +1. The time now is 12:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com