+ Reply to Thread
Results 1 to 3 of 3

Protecting Worksheet Cells

  1. #1
    LY
    Guest

    Protecting Worksheet Cells

    I am creating a form in Excel and protecting the cells I don't want users to
    be able to edit. This also allows me to hit the tab or enter keys to jump
    to the next available cell. I am able to hit "tab" so it jumps to each
    available cell from left to right, but at the end of the first row, it jumps
    to columns on the right of the form which have no data in them and will go
    on infinitely. So, I have to hit "enter" at the end of each row to move
    down, then "home" to go the far left side of the form.

    Is there a way to direct the "tab" key to wrap to the next row, first
    available cell? Or is there another solution?

    Thanks!



  2. #2
    Anne Troy
    Guest

    Re: Protecting Worksheet Cells

    The best solution is to protect ALL cells, and then protect only the cells
    you want them to be allowed to edit.
    That way, it won't jump to those columns that aren't being used.
    *******************
    ~Anne Troy

    www.OfficeArticles.com
    www.MyExpertsOnline.com


    "LY" <LY@cm.NOSPAMcomm> wrote in message
    news:u5J%23eMpdFHA.2076@TK2MSFTNGP15.phx.gbl...
    > I am creating a form in Excel and protecting the cells I don't want users

    to
    > be able to edit. This also allows me to hit the tab or enter keys to jump
    > to the next available cell. I am able to hit "tab" so it jumps to each
    > available cell from left to right, but at the end of the first row, it

    jumps
    > to columns on the right of the form which have no data in them and will go
    > on infinitely. So, I have to hit "enter" at the end of each row to move
    > down, then "home" to go the far left side of the form.
    >
    > Is there a way to direct the "tab" key to wrap to the next row, first
    > available cell? Or is there another solution?
    >
    > Thanks!
    >
    >




  3. #3
    Dave Peterson
    Guest

    Re: Protecting Worksheet Cells

    And after you lock/unlock the cells, the worksheet has to be protected.

    Format|Cells|protection tab (to lock/unlock)

    Tools|Protection|protect sheet (to protect the worksheet)

    Anne Troy wrote:
    >
    > The best solution is to protect ALL cells, and then protect only the cells
    > you want them to be allowed to edit.
    > That way, it won't jump to those columns that aren't being used.
    > *******************
    > ~Anne Troy
    >
    > www.OfficeArticles.com
    > www.MyExpertsOnline.com
    >
    > "LY" <LY@cm.NOSPAMcomm> wrote in message
    > news:u5J%23eMpdFHA.2076@TK2MSFTNGP15.phx.gbl...
    > > I am creating a form in Excel and protecting the cells I don't want users

    > to
    > > be able to edit. This also allows me to hit the tab or enter keys to jump
    > > to the next available cell. I am able to hit "tab" so it jumps to each
    > > available cell from left to right, but at the end of the first row, it

    > jumps
    > > to columns on the right of the form which have no data in them and will go
    > > on infinitely. So, I have to hit "enter" at the end of each row to move
    > > down, then "home" to go the far left side of the form.
    > >
    > > Is there a way to direct the "tab" key to wrap to the next row, first
    > > available cell? Or is there another solution?
    > >
    > > Thanks!
    > >
    > >


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1