Protection not working

[Mike Harris]

I have a protected excel file that I want to unprotect
permanently. When I unprotect the file, save and close it
and then reopen the file, the protection is still
activated. Is there another option/setting that I need to
change because I only unlocked certain columns and then
protected the file?

 

[Vasant Nanavati]

Hi Mike:

Are you sure you're not confusing file protection with workbook/worksheet
protection? What exactly do you mean by "the protection is still activated"?

Regards,

Vasant.

 

[StarTrek an beyond]

Remove protection from an entire workbook On the Tools menu, point to
Protection, and then click Unprotect Workbook.

 

[Mike Harris]

I have done this already as per line 3 in my original
message the problem is it is still protected when I reopen
the file.

 

[Ken]

My guess is that there's a macro that's protecting the sheets/book. If
you're asked if you wish to enable macros when you first open, I'd be
looking in there.

Ken

 

[Vasant Nanavati]

Mike, as Ken pointed out, there is probably a Workbook_Open macro that is
reprotecting the worksheet. Look in the ThisWorkbook code module and delete
the offending macro.

Regards,

Vasant.