Hi,
Have you tried using the navigator. it's on the formula bar at far left. a
little dropdown like a combo box which displays range names and print areas
and other.

FSt1

"Tim Marsh" wrote:

Hi All,

I have created a combobox on a worksheet which, upon activation of the
sheet, gets populated with the names of all the 'named ranges' in the
workbook. selecting one of these takes you to the named range chosen. it
all works fine, but now i want to have it (or something similar) in a
toolbar... can anyone tell me how to do it? i don't know how to get
something like a combobox into a toolbar (eg, like the font selection
drop-down).

part of the reason for doing the above is that i create quite a few dynamic
ranges (via VBA) and they never appear on the 'go to' window ('Edit' - 'Go
To...'). can anyone tell me why they don't appear when other named ranges
do and is there anyway of forcing them on to that list (using VBA)?

Thanks for any help,

Tim