Hello,
My first question is hopefully an easy one:
is there a way to set multiple scroll areas on one sheet. i'm
building "The Big Sheet" among other worksheets in the workbook. i'd
like the user to use navigation buttons and hyperlinks to get around
and ALSO to limit the ScrollArea in each little part of the sheet. If
there is a way to link the ranges, i can't figure it out.
Thanks on that question.

I also have many combo boxes. i can't figure out how to populate the
boxes
once, and then stay that way throughout the life of the file.
All i have is a button to press to populate the boxes using AddItem's,
etc.
which works good, but i don't want to have to use a button. I also
don't want the user's selection to disappear when they click on list
button a second time.
I guess my question is, how can i set the combobox values permanently.
So, when the user opens my template application, the boxes are
populated and in there "initialized" state. But, from then on, after
SaveAs, and multiple open/closes, the boxes stay the way the user left
them. At the end of
file use, the last step will copy the combobox values where needed.
It seems simple, what event to use: worksheet_click (then, all boxes
are zeroed
when populated)
I may need an IF statement to clear and populate the comboboxes ONLY
if
they are empty??

Greatly appreciate any Help on either of these?
Thanks!

Steve