Results 1 to 4 of 4

Thread: How to prevent changing of Author in Microsoft Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    26

    How to prevent changing of Author in Microsoft Excel

    I am teaching my class excel and the students have to save their homework files to a network folder designated for them. I recently caught students taking copies of their homework files and transferring them via thumb drives to other students folders. the only reason I knew they did this was because I looked at the author property in file-properties and saw that the original author was not the user in whose folder it was in. I have a feeling as soon as i confront the students about cheating they will be looking for how I found out and a way around this. You can easily change the author on a file and I was wondering if anyone knew of a way to prevent this. Is there a registry entry that can be edited so that the author box is filled in automatically with the original user but can't be edited. Any help would be very appreciated.

  2. #2
    Join Date
    Nov 2010
    Posts
    503

    Re: How to prevent changing of Author in Microsoft Excel

    So you'd add this registry entry to their home PCs how?<g> No, no such entry in any case. I'm afraid that file properties are readily editable. It's probably impossible to know for certain who first saved a file. If you gave each student a file to start with, and each was subtlety different that might be a trace. But that's a lot of trouble, not fail safe and doesn't prevent students from 'sharing' the work that goes into completing the spreadsheet if not the spreadsheets themselves.

  3. #3
    Join Date
    Mar 2011
    Posts
    542

    Re: How to prevent changing of Author in Microsoft Excel

    For that you can block the excel sheet so that no one can modify the file summary. To avoid losing the contents of a cell or inadvertently change a value, you can lock access to the contents of a cell. Add this, select the cell in question, go to Format > Cells, click the Protection tab and check the Lock (normally it is checked by default). For a record to be kept out of any changes of cell contents or formatting, you must enable the protection of the sheet. Go to Tools> Protection> Protect Sheet. Enter a password to enable protection. You can still allow certain actions of the workbook by selecting from the list. Click on OK. All cells are marked as Locked readable but not editable.

  4. #4
    Join Date
    Jun 2011
    Posts
    798

    Re: How to prevent changing of Author in Microsoft Excel

    In Excel, can be handy to convenient security feature of the worksheet in case we need to distribute it to other users to compile a number of fields. In the Protect Sheet mask you can also choose a list of options to be granted any permissions to the user. Following the return of completed sheets, we can remove the protection from the menu by selecting Tools > Protection voice Unprotect Sheet.

Similar Threads

  1. Prevent user changing ACL / folder rights
    By Cyberscrap in forum Windows Server Help
    Replies: 4
    Last Post: 03-04-2012, 01:43 PM
  2. How to change Excel Author
    By RaaginiO in forum MS Office Support
    Replies: 3
    Last Post: 11-01-2012, 11:14 AM
  3. Prevent duplication of data entry in Excel
    By Chhaya in forum Windows Software
    Replies: 6
    Last Post: 15-12-2009, 06:06 PM
  4. How do I prevent router from changing my ip address
    By GeforceUser in forum Networking & Security
    Replies: 3
    Last Post: 25-05-2009, 10:36 PM
  5. NTFS Permissions to allow saving but prevent changing
    By zoomlmk in forum Operating Systems
    Replies: 5
    Last Post: 20-03-2009, 12:16 AM

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
  •  
Page generated in 1,711,701,716.30342 seconds with 17 queries