Hi All -

I have a front page with a few dynamic dropdowns that basically allow one of two choices and then a large list of secondary choices based on the 1st dropdown choice. This then generates a hyperlink (based on data validation 'indirect') which can be clicked to jump to one of many tabs within the worksheet.

Because this sheet will be used by many users, is there a way to reset the two dropdown boxes on the front page (either to blank, OR (even better) a message saying something like 'Make selection here...") IF either the hyperlink is clicked or the tab is changed (same difference, but I don't know which is easier to enact!). I have put in some macro that will reset the second box automatically if the first is erased but ideally would like it more automated in nature?

If this can be done without macro, great, though based on my research I think it has to be macro?

Thanks,

Stuart

PS - as an aside, does anyone know at what point a macro disables the UNDO stack? As some macros do this and some don't as far as I can tell?