Protection not working

  • Thread starter Thread starter Mike Harris
  • Start date Start date
M

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?
 
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.
 
Remove protection from an entire workbook On the Tools menu, point to
Protection, and then click Unprotect Workbook.
 
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.
 
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
 
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.
 
Back
Top