This week's Office challenge tests your knowledge of Access controls and reveals the answer to last week's challenge on protecting Excel workbooks.
When you insert new controls into a form, Access includes a label control. Depending on your conventions, you might not use those labels, which means extra work for you because you have to delete them. Luckily, you can inhibit those labels. Do you know how?
Last week we asked…
How do you password-protect an Excel workbook? Thanks to everyone for the great conversation. OurITLady, LAWRENCE KINUTHIA, Super_sonix, Neon Samurai, and Darryl all provided the right instructions:
In Excel 2007, click the Office button and choose Save As. In the Save As dialog box, click Tools and then General.
A special thank you to Neon Samurai and Darryl for such informative responses. Setting a password is a simple process, but protecting your data is a complex subject.
- From the Tools menu, choose Options.
- Click the Security tab.
- Enter the password(s) for opening and/or modifying the workbook.
- Click OK.