freeze pane

[kevin carter]

hi

i have a workbook that contains several worksheets
Each worksheet contains a lopt of formulas which i have oved to the far
right og the worksheet.
i then froze the pane from the windows drop down menu(i dont want the
formulas viewed or tampered with)
problem is someone keeps unfreezeing the pane
is it posible to freezer the pane using VB code?

thanks


kevin

 

[Harald Staff]

Sure. Record a macro while doing it, and voilá.

 

[kevin carter]

thanks

Sure. Record a macro while doing it, and voilá.

 

[Gord Dibben]

Kevin

Freezing panes will not prevent someone from scrolling to the right side of
your worksheet.

You may want to try setting the Scroll Area.

This setting will not remain after closing the file.
Place a code line in the Workbook open event to set it
each time when you open the workbook

Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "A1:M35"
End Sub

Gord Dibben Excel MVP