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 |
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 |
All times are GMT +1. The time now is 10:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com