Event Macro to display a selected cell in target cell

Hi All,

Long time user first time poster!

I am creating a spreadsheet for my school and have come to a dead end.

I need to create a macro that when a user double clicks or right clicks on a cell in the first row of "Sheet 1", Cell A1 displays the contents of a cell in same cell as the one double clicked in a different worksheet.

For example

I double click cell B1 in Sheet 1, and cell A1 displays the contents of cell B1 in sheet2.

Any help would be greatly appreciated!

Thanks in advance

You can place this macro in the sheet1's code and try if it would help.

Please Login or Register  to view this content.

Regards,
Sindhu

Thanks Sindhus,

It works a charm when my worksheet is not protected but i get a runtime error when it is protected.

Any suggestions?

But you cannot double click on the sheet, when it is protected right?

I can if the cells are not locked

Ya. Then You mean to say you are double clicking on the unlocked cells? Then make sure Range("A1") is also unlocked. Because the macro writes in A1 cell.

Sindhus you are a legend!

Thanks for your assistance