Macro Button Inputting into Any Cell

I have a button macro, specifying a cell to input a value to, but if I highlight any other cell on the worksheet then select the button, the value is input in the highlighted cell. I've protected the sheet but had to leave two cells unprotected...these being the cell (D1) the macro is to place the value "South" and a cell with a defined drop down list. But if a user makes a selection from the drop down, then selects a macro button, the value is input in the drop down cell.

Is there any way of stopping this from happening?

My vba for the button is:

Please Login or Register  to view this content.

Is there any way of stopping this from happening?

Not with the code as it is - whatever cell is selected will be updated and you don't give enough information to suggest any possible answers.

If the user makes a selection from the drop down then that cell becomes the active cell so your code is doing what it's meant to.

Do you mean after they make a selection you want D1 to update to say "South"?

In which case, why not just use

Please Login or Register  to view this content.

?

BSB

Thank for the help.

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

both work as I need so thank you.

Happy to help.
Thanks for the rep point

BSB