| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a macro to re-create a format?
I have a spreadsheet with some basic formatting - column headings in
bold with a background colour and borders, column widths, Freeze Panes, and AutoFilter applied. I want to make macros to re-create these sheets from scratch, does anyone know of an add-on or a macro that will help me do this? I don't mind going through manually streamlining it afterwards, as I would if I were recording it. Phil Hibbs. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create a macro to re-create a format?
Save the formated file as a template and then use the template everytime you start. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=175511 Microsoft Office Help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
| can you record a macro that will create/format a pivot tablle? | Excel Discussion (Misc queries) | |||
| Create WB, create new Sht, paste data. (Macro not working) | Excel Programming | |||
| create Macro €“ select data, sort by acc no., yr, part no, create P | Excel Programming | |||
| Macro to create format painter | Excel Programming | |||
Hybrid Mode
