Hi,

Not being familiar with VBA ,I've created a new single sheet Workbook;
copied the data from one worksheet; set column widths to match original
and created the print setup all, using the Macro Recorder.

My question is this, because I used the recorder (I assume) the new
workbook/sheet flickers a lot whilst formatting etc takes place - Is
there a way to hide the new wookbook until the macro has completed?

Thanks in advance,

Dave


--
deelee
------------------------------------------------------------------------
deelee's Profile: http://www.excelforum.com/member.php...o&userid=34866
View this thread: http://www.excelforum.com/showthread...hreadid=555343