View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How can I move from one desired cell to another in Excel using

Thanks for the feedback and I'm sorry you spent some time trying to figure out
what I was talking about with the typo.


Gord

On Tue, 15 Aug 2006 18:22:02 -0700, pibedoro
wrote:

I managed to do it. I did not understand your full concept but I understood
that it had something to do with checking locked cells.

Now I can move from one cell to the next using the TAB button.


many thanks anyway

"Gord Dibben" wrote:

Typo in this..........sorry for the confusion.

When protecting the worksheet check the "select locked cells" and uncheck
"select locked cells"

Should read.................

When protecting the worksheet check the "select unlocked cells" and uncheck
"select locked cells"


Gord

On Sun, 13 Aug 2006 19:33:01 -0700, pibedoro
wrote:

what sorry, check and uncheck ''select locked cells''?
What would Checking and unchecking it again change?

many thanks for replying




Gord Dibben MS Excel MVP