+ Reply to Thread
Results 1 to 4 of 4

Locking all the cells in a spreadsheet but leave a few open

Hybrid View

  1. #1
    Registered User
    Join Date
    11-29-2006
    Posts
    17

    Locking all the cells in a spreadsheet but leave a few open

    What I am trying to do is lock all the cells in the attached spreadsheet except the start and finish time cells. i.e The people who use this can only enter a charachter in the 2 cells for any given day. I thought I had made a simple spreadsheet here for a few of my temps to use but they managed to completley mess up last months time sheet.

    Thanks in advanced
    Attached Files Attached Files

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Attached is your worksheet corrected ...

    Protecting is a two step process
    1. Selectively Lock and Unlock your cells
    2. Protect Sheet ( for the above selection to be turned on...)

    HTH
    Carim
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-29-2006
    Posts
    17
    Quote Originally Posted by Carim
    Hi,

    Attached is your worksheet corrected ...

    Protecting is a two step process
    1. Selectively Lock and Unlock your cells
    2. Protect Sheet ( for the above selection to be turned on...)

    HTH
    Carim

    Thank you I am eternaly grateful, have a very merry christmas

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Glad it fixed your problem ...

    Thanks for the feedback

    Carim

+ 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