Limit (working of) macro to a specified cell range

Hi there,

this code inserts a date and the username into the pre-selected (unlocked) cell. If there is something already in that cell, it inserts a line below rather then overwriting it.
If by any chance he clicks onto a locked cell and runs the macro, it will not work due to the locked cell feature (an elegant way around the debug mode is the "On Error GoTo")

Please Login or Register  to view this content.

But to avoid letting users click on other cells, which are unlocked but meant for other information input, I would like to limit working of that macro to just a range of cells, e.g. B10:B50.
So, if you click within the range, the macro works, otherwise it does nothing.

Thanks for the help.

Originally Posted by Olly

Try:

Please Login or Register  to view this content.

Hey Olly,
thank you very much.
Exactly what I wanted, works perfectly.

Consider this SOLVED

Regards