Prevent Users from Unfreezing Panes

alekche

New Member
Joined
Mar 23, 2011
Messages
2
hi there

I have a Excel 2003 workbook that has a protected worksheet.

I have two passwords that users can use to edit certain cell ranges.

I want to however prevent the users from unfreezing the panes. The worksheet is currently frozen at cell K3, but it appears that users can unfreeze the sheet.

Do I need a Macro, as I can't see the 'freeze/unfreeze' option on what users can do in the protected worksheet tools>protection>protect sheet

If this is not possible for Excel 2003
Can I create a macro that always freezes the worksheet at cell K3?

thanks for your help
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

antaeusguy

Board Regular
Joined
Mar 8, 2010
Messages
81
You should protect the workbook windows

Go to Tools > Protection > Protect Workbook

Under Protect workbook for.. , tick "Windows"
 

Watch MrExcel Video

Forum statistics

Threads
1,108,987
Messages
5,526,069
Members
409,685
Latest member
Davetom

This Week's Hot Topics

Top