1. Sekolah Dasar
  2. Sekolah Menengah Pertama
  3. Sekolah Menengah Atas
  4. Mata Pelajaran
  5. Programming

Vba Print Visible And Hidden Worksheets

[Solved] Vba Print Visible And Hidden Worksheets | Vb - Code Explorer | yomemimo.com
Question : VBA - Print Only Hidden Worksheets

Answered by : michael-futral

Sub PrintOnlyHiddenWorksheets() Dim CurVis As Long Dim sh As Worksheet For Each sh In ActiveWorkbook.Worksheets With sh CurVis = .Visible If CurVis >= 0 Then .Visible = xlSheetVisible .PrintOut .Visible = CurVis End If End With Next sh
End Sub

Source : https://www.excelhowto.com/macros/print-worksheets-vba/ | Last Update : Fri, 29 Apr 22

Question : VBA - Print Visible and Hidden Worksheets

Answered by : michael-futral

Sub PrintHiddenAndVisibleWorksheets() Dim CurVis As Long Dim sh As Worksheet For Each sh In ActiveWorkbook.Worksheets With sh CurVis = .Visible .Visible = xlSheetVisible .PrintOut .Visible = CurVis End With Next sh
End Sub

Source : https://www.excelhowto.com/macros/print-worksheets-vba/ | Last Update : Fri, 29 Apr 22

Answers related to vba print visible and hidden worksheets

Code Explorer Popular Question For Vb