When you hide a worksheet, it is even hidden from normal macro operations.The upshot of this is that if you want to run a macro and have it access information on a hidden worksheet, you must first "unhide" the worksheet.This means that the Excel screen can look like it has "gone crazy" while the macro is running.
Sub Freeze All Sheets() ' ws A As Worksheet Dim ws As Worksheet Dim wb A As Workbook Dim str Sel As String Dim l Rsp As Long On Error Go To err Handler Set wb A = Active Workbook Set ws A = Active Sheet str Sel = Selection. When the macro starts, it will show a confirmation message. Activate Else 'do nothing End If exit Handler: Application.Click Yes to go ahead with the unfreezing, and click No to cancel. Activate Else 'do nothing End If exit Handler: Application.In this screen shot, row 5 is selected, so rows 1 to 4 will be frozen on all sheets, if the Yes button is clicked. Screen Updating = True Exit Sub err Handler: Msg Box "Could not freeze all sheets" Resume exit Handler End Sub Use this macro to unfreeze all the sheets in the active workbook.I'll be checking this thread religiously, so if you need any more information just let me know... hi CBishop, welcome to don't worry abt being a newbie, just take yr time reading the posts in Ozgrid and be sure to abide by the rules attached is a sample for consolidating sheets into one.have a look at it, study it and post back if you have any questions Okay, that's really close to what I need.