Excel 2007 : Macro using drop down on seperate sheet

[Sazza]

Morning All,

I have found part of the solution to my query here :

http://www.mrexcel.com/forum/showthread.php?t=474424

Which is hiding columns depending on a dropdown on the same worksheet.

My question is whether i can tweek this so that i can use a dropdown on another worksheet tab ?

I have this code below on worksheet 4 which is working off a dropdown on worksheet 4 ( which is a replica of a drop down on worksheet1)

How can i update this to use the dropdown on worksheet tab 1 ?

Please Login or Register  to view this content.

[royUK]

Try this

Please Login or Register  to view this content.