The initial problem was to avoid manually changing the style to all named ranges or applying the style to new named ranges.
Thanks @kev_ . the vba solution does exactly what I need.