CTRL+Z Locks/Protects Worksheet

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

Has anyone experienced a transient problem of having
CTRL+Z locking / protecting the worksheet and assigning
an unknown password? Of course that keystroke combo is
supposed to perform an "undo".
 
Hi Greg,
Has anyone experienced a transient problem of having
CTRL+Z locking / protecting the worksheet and assigning
an unknown password?
Click to expand...

A macro in a workbook or in an addin has hijacked your control-z key.

Try these:

1 Tools, Add-ins
2 note which are checked
3 uncheck all (but one)
4 restart XL
5 if no error, check the next one and repeat from step 4

Got the error? uncheck the one you last checked.

Not an add-in? It will be a (hidden) workbook then.

1 Find your XLSTART folder
2 Move all files out of it
3 Open them one by one and find the one with the error
4 move the others back

Repeat the above for the folder listed in Tools, Options, General,
"Alternate Startup file location"

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Back
Top