Home |
Search |
Today's Posts |
#1
|
|||
|
|||
change one sheet, and automatically the others
As follow up for my freezing question. Is it possible to submit this change
(freezing pane) to all worksheets at the same time without changing the rest of the content of the sheets (it's the same cell) Sorry if this is a repeated question(, I couldn't find the answer anywhere else). Cheers, Ruth |
#2
|
|||
|
|||
Dummie
Freezing Panes is a function of the Active Window. Would require VBA code to Freeze all sheets. Sub Freeze_Panes() Dim ws As Worksheet Application.ScreenUpdating = False For Each ws In ActiveWorkbook.Worksheets ws.Activate Range("B2").Select ActiveWindow.FreezePanes = True Next ws Application.ScreenUpdating = True End Sub Gord Dibben Excel MVP On Wed, 17 Nov 2004 07:03:02 -0800, Dummie wrote: As follow up for my freezing question. Is it possible to submit this change (freezing pane) to all worksheets at the same time without changing the rest of the content of the sheets (it's the same cell) Sorry if this is a repeated question(, I couldn't find the answer anywhere else). Cheers, Ruth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
in excel, how do i set up a spread sheet that automatically total. | New Users to Excel | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
How do I automatically rename a sheet with the contents of a cell. | Excel Discussion (Misc queries) | |||
Automatically pull data into another worksheet within the same fil | Excel Worksheet Functions | |||
getting data from 2 excel sheets automatically | Excel Worksheet Functions |