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:
- From the Tools menu, choose Options.
- Click the Security tab.
- Enter the password(s) for opening and/or modifying the workbook.
- Click OK.