Style available all sheets new or old

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I need a custom style that is available in all
spreadsheets, new or old. I can set style and save it in
book.xlt in xlstart, but that only works for new
workbooks, and doesn't work with old spreadsheets when I
call them up. I want to be able to select a group of
cells, or column or row and apply a setting for negative
numbers to have brackets. I am using Excel 2000.

I even tried saving the style in personal.xls, but that
doesn't work as it is hidden.

Do I have to use a macro? And if so what would it be?

Thanks
 
One way:

Public Sub MergeStyles()
ActiveWorkbook.Styles.Merge _
Workbook:=Workbooks("Personal.xls")
End Sub
 
Thanks, just curious is there a way to automate the pop up
that asks to merge style with the same name, to say no.
 
Back
Top