Reset all dropdown selections if tab change?

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?

YOu can add "Make a selection here.." to your dropdown lists at the top

then you can put that value in the cells with the dropdown box
by a simple Range("A1").Value = "make a selection here"

put this code in the worksheet_followhyperlink or worksheet_deactivate event macro

Thanks Roel -

I've added this to the dropdowns, but can't get the macro to work?

The first dropdown is in cell B2, and the second in D2. The 'Go' button (i.e. hyperlink) is in E2.

So on pressing cell E2, which would hyperlink to another tab, that is the point at which I'm looking for both B2 and D2 dropdown selections to reset to blank or the 'Make Selection...'.

I don't do much Macro work so far to be honest

Thanks,

Stuart