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.
 
V

venkat1926

Joined
Sep 20, 2009
Messages
47
Reaction score
2
The best method in a new workbook CREATE a macro and then you will be able to edit to suit you
 

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

Pasting cell contents into a macro 1
Autofilter in a macro 1
Help to create a macro 2
Macro to create format painter 7
Re: Reference must be to a macro sheet? 0
How to apply a macro to all workbooks 2
Search column...change row to BOLD 6
Word Create a Phone Book using MailMerge in word 2007 0

Top