Offset VBA - Cursor Navigation

Quick question,

I have produced a very simple macro which basically just clicks the left arrow key once to the left, I believe this is correct

ActiveCell.Offset(0, -1).Select

My problem is the above line of code ignores the cell protection, I have protected the page and left only the cells I want the user to click in unlocked.

Can anyone advise how I could modify the above code to add this ability in?

Thanks in advance.

Darren

Hi Pierre, unfortunately didnt work, hmm.

Hi Pierre,

Thanks for that, I can see the issue now,

What I did on my file was something similar to the following on your file:

B27, when macro is run I would need the cursor to move to I26.

I can see how that would complicate things, any workaround?

Darren

Thinking about it, I could simply use a 2nd macro going to the right in that situation.

Any chance you could modify your original code to move to the right please?

I think this would be the simplest option

Darren

Hi Pierre,

After relooking at the file I am working on I would have to go up 1 row and then across 1 to the right.

If you can modify your original code for this I would be very grateful, if not thats ok mate.

I have already given you rep

Thanks again
Darren