how to freeze panes in excel mac for multiple lines

Ze Panes In Excel For Multiple Lines Code Yet There

I dont know the age of those websites so I have no idea if colons are still okay but on my Office 365 system which includes the latest version of Excel the works.

The new - 2 window on the right does not retain these settings.

Changes to the data and objects within the workbook will be applied immediately to all open windows of the same file.

You dont have to worry about losing data or modifications you make to the workbook when two windows are open.

Headings: If you turned the rowcolumn headings off for any sheet, those will also be turned on.

It can be VERY time consuming to set them back to how you had them originally.

So I created a macro that will help save you time when creating new windows.

Loops through all sheets in the new window and applies all of the following settings from the original window: Gridlines, Freeze Panes, and Headings.

The macro identifies the cell (rowcolumn) that the freeze panes are applied to and applies it the same way to the new window.

The sheets must be activated in the loop to apply the window level settings.

Arrange the windows in vertical side-by-side split screen view.

The split screen can cause the active sheet tab to be out of view.

Dim ws As Worksheet Dim i As Long Dim iWinCnt As Long Dim bGrid As Boolean Dim bPanes As Boolean Dim bHeadings As Boolean Dim iSplitRow As Long Dim iSplitCol As Long Dim iActive As Long Dim iZoom As Long Dim sSep As String Application.ScreenUpdating False Store the active sheet iActive ActiveSheet.Index Create new window ActiveWindow.NewWindow iWinCnt ActiveWorkbook.Windows.Count Set the separator based on the version of Excel Office 365 now using a dash If InStr(:, ActiveWorkbook.Name) 0 Then sSep: Else sSep - End If Loop through worksheets of original workbook and apply grid line settings to each sheet.

Turn screen updating on for split screen Application.ScreenUpdating True For i iWinCnt To 1 Step -1 Windows(ActiveWorkbook.Name sSep i).Activate Next i Split view side-by-side vertical ActiveWorkbook.Windows.Arrange ArrangeStyle:xlVertical Scroll to active tab in original window ActiveWindow.ScrollWorkbookTabs Position:xlFirst ActiveWindow.ScrollWorkbookTabs Sheets:iActive Scroll to active tab in new window Windows(ActiveWorkbook.Name sSep iWinCnt).Activate DoEvents ActiveWindow.ScrollWorkbookTabs Position:xlFirst ActiveWindow.ScrollWorkbookTabs Sheets:iActive End Sub.

If working in split screen, you will likely want to maximize the original window as well.

You can do this by dragging the mWindow module from the example file into your PMW in the VB Editor.

This is optional, but makes it much easier to quickly run the macros.

Here is a post on the Excel Uservoice site where you can vote for it.

However, the issue with losing the window level settings can be frustrating and time consuming.

Ze Panes In Excel For Multiple Lines Code Yet There

That appears to be the only variable in the offending line of code yet there are two windows; the original one and the newly created one.

I will continue to review your code but I am hoping you can tell me what is wrong.

I updated the code to work on older versions of Excel that use the colon instead of dash for the new window name.

I found that my Excel doesnt like your syntax, in the lines that name a Window something like this: Windows(ActiveWorkbook.Name iWinCnt).

How To Freeze Panes In Excel Mac For Multiple Lines