creating a named row for dynamic addressing

p45cal · #1 07-08-2018, 03:21 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating Dynamic Ranking Tables	ssol2016	Excel	1	10-27-2016 08:47 AM
creating a code to create dynamic text in word	ah8471	Word VBA	1	12-29-2015 10:52 PM
Creating a dynamic summary sheet	FenelonPaul	Excel	5	09-23-2015 07:11 AM
Help Creating A Dynamic Footer	Mikemo	Word	3	02-05-2013 11:58 AM
Dynamic Named Ranges using text	hannu	Excel	0	06-22-2010 04:42 PM