Depends on what you mean by automate.
Jan Karel kind of automates it in his addin--but the user still needs to respond
to the dialog.
If you mean that, then you could do the same kind of thing--toggle that setting
and have the user ready to answer the prompt.
"P. Dua-Brown" wrote:
Hi Dave
Thanks for the link. My query is it possible to automate the manual method
you've stated?
Regards
Preeti
"Dave Peterson" wrote in message
...
Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager has
the ability to fix these invalid names.
You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp
You can also do it manually.
Tools|options|General|check r1c1 reference style
then
Tools|options|General|uncheck r1c1 reference style
You'll be prompted at one of these steps to supply a new name for those
invalid
names. (I forget which one!)
"P. Dua-Brown" wrote:
Hi
I'm using Excel 2003 and would like to know if the following is
possible.
Some of the spreadsheets used in the office started life in Lotus 1-2-3
and
now contain loads of defined names! I can remove most of the names but
some
are a bit more tricky as they contain characters such as %, $, & and
even
squares.
Reading through past threads I have figured out that by switching to
R1C1
notation through the Tools, Options, General tab I can rename the
invalid
ones. So I use Application.ReferenceStyle = xlR1C1 to switch over and
then
the Name Conflict dialog box is displayed and I'm able to enter new
names
(one at a time) for each of the invalid ones. What I would like to do is
automate the renaming of the invalid names in the Name Conflict dialog
box
to Junk1, Junk2 etc.
Is this possible???
Many thanks
Preeti
--
Dave Peterson
--
Dave Peterson