Me again, last one today!
IL have some files to be used by several users, now I don't want them to be able to change some of the rows and cells. So I'm the only one who can change them. How do I do this?
Thanks again,
ADB
Me again, last one today!
IL have some files to be used by several users, now I don't want them to be able to change some of the rows and cells. So I'm the only one who can change them. How do I do this?
Thanks again,
ADB
Last edited by ADB; 12-13-2009 at 02:06 AM.
Hi ADB,
That is available under "Tools > Protection..."
Just search for "Protection" in the Excel Help.
Cheers,
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
Hi,
Thanks for replying so quickly. I tried that, but no success. I want others to use my file on a server, but they should not be able to change formulas. Data entry should be possible, but some cells should not be touched. I can't find that in help!
ADB
Last edited by ADB; 12-11-2009 at 04:57 AM.
Hi ADB,
Note that under "Format > Cells > Protection" each cell of a worksheet may be locked or have a formula hidden. To use this feature, you must enable "Protect Sheet...". Excel will give you the choice of which actions your users may conduct on a protected sheet. For those cells you do not want protected, you must remove the cell protection in the format dialog box.
Cheers,
Hi,
I didn't really follow you, but after reading this: http://www.uwgb.edu/compserv/ehelp/excel/protect.htm I understand what you mean. Maybe I need the visual help...
Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks