creating a named row for dynamic addressing

p45cal · #9 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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