Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I use the following code to print all visible worksheets. Can it be modified to NOT print a worksheet which is called "Main"? thanks! Sub Print_Visible_Worksheets() 'xlSheetVisible = -1 Dim sh As Worksheet Dim arr() As String Dim N As Integer N = 0 For Each sh In ThisWorkbook.Worksheets If sh.Visible = -1 Then N = N + 1 ReDim Preserve arr(1 To N) arr(N) = sh.Name End If Next With ThisWorkbook .Worksheets(arr).PrintOut .Worksheets(1).Select End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
modification to this code | Excel Discussion (Misc queries) | |||
Code modification help please | Excel Programming | |||
Modification in the CODE to HIDE rows and columns that start with ZERO (code given) | Excel Programming | |||
modification for the code | Excel Programming | |||
Code Modification | Excel Programming |