Text Box Format Default

A

ajr81

I use Excel '07. Is there a way to save the default settings to a desired
format when you insert a new text box so you don't have to change it each
time?
 
H

Héctor Miguel

hi, !
I use Excel '07.
Is there a way to save the default settings to a desired format when you insert a new text box
so you don't have to change it each time?
Click to expand...

what type of "text box" ?

- activeX ?
maybe storing one of them pre-formatted as a "template" and copy/paste
(according your needs: userform, embedded over a worksheet)

- drawing object/shape ?
- select the shape and right-click on the boundaries...
- from the contextual menu, choose "default format..." (or something like that) ?

hth,
hector.
 
Top