Thread: [Solved] creating a named row for dynamic addressing
View Single Post
 
Old 07-08-2018, 03:21 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
  
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
If a sheet is hidden it has to be unhidden before printing, however briefly. This process can be largely hidden from the user with the likes of:
Code:
Application.ScreenUpdating = False
With Sheets("Sheet1")
  originalVisibility = .Visible
  .Visible = xlSheetVisible
  .PrintOut
  .Visible = originalVisibility
End With
Application.ScreenUpdating = True
where the sheet is restored to its original visibilty after the print instruction.
Reply With Quote