- From the Tools menu, choose Options.
- Click the Security tab.
- Enter the password(s) for opening and/or modifying the workbook.
- Click OK.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.