Autofromatting!

[vgurusa]

Hi Ppl,

How to format the Worksheet programatically from a software like Visua
Basic ?

For e.g. the worksheets specific rows have to be changed int
numberformat="Number" instead of default "General"

Thanks,

Vija

 

[Gord Dibben]

Vijay

It can be done but some more detail would be handy.

All worksheets of new books?

All worksheets of existing books?

Some sheets or one sheet?

Are the rows contiguous or interspersed throughout?

Could be as simple as creating a template upon which all new books are based
or a sheet template for new sheets.

Existing sheets and books would require VBA code, either workbook_open or
sheet_activate or similar.


Gord Dibben Excel MVP