Auto Formatting A New Worksheet
 

I am creating a NEW spreadsheet (as part of the normal processing) using MS
Access (my expertise is in Access). I can write code in Excel to
automatically custom format each tab (10 Total Tabs) in the spreadsheet.

The Question is:
How do I preserve this code and automatically apply the formating to a newly
created spreadsheet automatically?

Many Thanks

Ross

Auto Formatting A New Worksheet
 

Hi Ross,

maybe you should consider using template in Excel.

Regards,
Ivan