How do I freeze panes in protected worksheet?

[Sandra Poh]

Dear Officer in charge,

Is there any way to do VBA to enable the user to freeze and unfreeze panes
in a protected worksheet of a protected file? Pls advise urgently.

Regards
Sandra

 

[Bob Greenblatt]

Dear Officer in charge,

Is there any way to do VBA to enable the user to freeze and unfreeze panes
in a protected worksheet of a protected file? Pls advise urgently.

Regards
Sandra

The simple answer is no, not on a Mac. If you are changing characteristics
of the sheet or workbook with vba, you must unprotect the sheet or workbook,
do what you need to do in code, and then reprotect it. The Mac does not have
the fine resolution of protected items that exists in the Windows
environment.

 

[Sandra Poh]

Dear Bob,
Seems no choice. I will then use the split function to replace freeze panes
then.
A lot of thanks for your quick response.

Regards
Sandra