hi all,

some help with the code below, what i need it to do is when a cell is selected (so when you click once on it) it unhides a hidden sheet and takes you to a certain range. It does not seem to work. Also this code will be placed into 12 sheets.

It appears that what ever cell i click it unhides the hidden sheet and stops the macro.

Thanks
Paul

Please Login or Register  to view this content.