Create a macro to re-create a format?

P

Phil Hibbs

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Format Multiple Sheets based on "Master" Format 0
VBA - (re-) Set a Table Style 2
Filling a macro button with colour ( color) 4
Automatic conditional formatting from a list 0
Excel 2007 Conditional Formatting 1
Do Until Macro 6
Macro for Thick Borders using conditional formatting 0
Discrepancy between manually formatting sheet vs. using VBA macro 5

Top