Sign-in / Sign-up
Your question

Lock excel files

Tags:
  • Programming
  • Excel
  • Apps
Last response: in Apps General Discussion
January 8, 2010 9:31:37 AM

How to Lock excel Sheet/File

More about : lock excel files

a b L Programming
January 8, 2010 5:41:14 PM

Change the permission on the file so only the people you want to have access to it have access to it.

You can use this to learn about file permissions in windows:
http://support.microsoft.com/kb/308419
m
0
l
January 11, 2010 3:45:54 PM

Hi Rajesh,

In Excel 2003 go to Tools -> Protection -> Protect Sheet.
In Excel 2007 go to Review -> Protect Sheet.

There you can protect the sheet with a password or simply to keep yourself or others from changing only the necessary fields.
Please let me know if that's what you were looking for.

Regards
m
0
l