Thursday, 7 December 2017

Excel Questions and Answers Part 4

Passwords and Protection 

How can I protect formulas from being deleted or changed? 

I've lost my password! 

How can I protect an Excel file (and associated code) from unauthorized copying and/or create time limited functionality? 

Is there a way to allow the use of AutoFilter on a protected worksheet? 

When you protect the sheet, add a check mark to the option for "Use AutoFilter".


Can I prevent people from opening a file without a password?




Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London









No comments:

Post a Comment