SAME Cell selection across the workbook

Hi,
I hope someone can help me with this little problem..
Other than using the alt key to select multiple worksheets and then clicking a cell, then clicking the tab of the sheet required and finding the same cell already selected...is it possible using VBA, to synchronize the same cell selection throughout a workbook.. ie so that on all sheets the same cell is always selected?
just as a working example
On sheet 1, select C9 make a change to that cell
then going to sheet 2, cell C9 should be already selected make a change to it then select cell A1..then going on to sheet 3, A1 already being selected,make any changes to it, select B2
Back on sheet 1 , B2 should be selected. etc etc.
Just for clarification, i dont need to sync any info across the sheets, i just need the same cell already selected.
many thanks for any help

Neil

This can be one way.

Please Login or Register  to view this content.

But you cannot select multiple cells at a time. To me, I find it as a pain.

Hi Neil,

Look at the attached. I have created a Public Variable to keep the address of the last selected cell on a sheet. Whenever you click on a new cell on that sheet it updates this global/public variable.

Then when you change sheets it selects the spot you were on, on the last sheet. You will need to have the same code behind each sheet and the Public variable in Module for this to work.

Hope this solves it for you.

You might try placing the below in ThisWorkbook in VBE

Please Login or Register  to view this content.

Per FAQ:

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You'll find most are self taught largely through trial & error.

The Macro Recorder is obviously a very useful tool for getting the basic syntax of most things in Excel.

In my opinion trying to answer questions on boards like this is the quickest and best way for picking up good skills covering a diverse range of Excel's functionality.