| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding New Workbook created using Macro Recorder
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Created but Not Running in Workbook | Excel Worksheet Functions | |||
| Password protect a workbook created and emailed by a macro? | Excel Programming | |||
| Macro run each time a new workbook created | Excel Discussion (Misc queries) | |||
| Runtime error for macro that works in workbook created in | Excel Discussion (Misc queries) | |||
| How do I copy macro into new workbook that was created automatica. | Excel Programming | |||
![deelee[_15_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
