What about a floating toolbar that has a dropdown in it? Would that work?
That would require that you put a macro in your workbook.

--
Regards,
Tom Ogilvy

"Ooz" wrote in message
...
Hi there,
In my workbook I have several worksheets all containing different
reports. In the first worksheet there is a cell which has a in-cell
dropdown list as a validation criteria. This cell defines the reporting
period for all other worksheets. ie when you change this cell to say 5,
all the other worksheets become the reports for period 5.
When viewing the reports generated in other worksheets it is
inconvenient to go back to the first one and chage the reporting period
every time.
Is there a way that I can change this cell say A1 in Sheet1 from each
individual report worksheets (say from Sheet2, Sheet3, ...Sheet14,
etc.
appreciate your time.
thx



------------------------------------------------
Message posted from http://www.ExcelTip.com/

-- View and post Excel related usenet messages directly from
http://www.ExcelTip.com/forum
-- Hundreds of free MS Excel tips, tricks and solutions at
http://www.ExcelTip.com/
------------------------------------------------