+ Reply to Thread
Results 1 to 2 of 2

Once entered cant be altered

  1. #1
    Registered User
    Join Date
    03-30-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    73

    Once entered cant be altered

    Hi all,

    am creating a spread sheet and i want to set a rule that once something has been saved to the spread sheet it cant be edited.

    so say if i go into it and fill in cells a1 to a6 then save and exit is there any way that the next person to enter the spread sheet will be unable to change any of the data previously entered??


    thanks people

    rick

  2. #2
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    245

    Re: Once entered cant be altered

    Lock those cells and password protect, with the rest of the cells unlocked. If you need to automate so it's done each time someone changes the sheet, it will have to be done with a macro.
    <--- If you like the answer, press *.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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