View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Gridlines Inadvertently Goes Away with Macro

After serious thinking JCO wrote :
Okay but that would print when you turn grids off for printing?


If you use Conditional Formatting to apply the dotted borders then you
can also switch these off for printing. All you need is a cell to
contain the switch 'flag' so you can toggle it how you want to
view/print your data.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion