ExcelBanter - Worksheet Protection

On Jun 4, 10:01 pm, James8309 wrote:
Hi Everyone

I have a macro running excel file and it is very sensitive. I don't
mind people opening up but I do mind people changing it.

How do I put security such as password to prevent others from editing
the excel file?
i.e. Anyone can open the file and run macro to create a report but
they can't edit anything!!!

p.s. I just know how to put password protection on the whole workbook
and this is useless because no one can open the file lol.

Thank you for your help in advance.

Regards,

James

Why can't anyone open a protected file? Maybe you are talking about a
Windows-level password protection. That isn't what you want for a
shared file.

Excel-level password protection works just fine. In Excel 2003 and
before, go to Tools menu, then to Protection. (I'm not exactly sure
where this is located in XL2007) You can protect worksheets and
workbooks separately. Sounds like you mainly want worksheet
protection. You also need to make sure your cells are locked, but that
is the default, so you are probably fine.

A very advanced user can no doubt find a way around it, but that
probably isn't the person messing up a file in the first place. But it
is quite good at stopping the standard users from screwing something
up.