Ms access password protect macro5/27/2023 ![]() Then click OK, select any cell, and stop recording. Select Tools » Macro » Record New Macro and choose Personal Macro Workbook from the Store Macro In: box. You can create one easily by recording a dummy macro. ![]() If this is grayed out, it means you do not have a Personal.xls file yet. Or, select Window » Unhide and unhide your Personal.xls file to make it available to any workbook. ![]() Open the workbook to which you want to apply the code. Sometimes, though, you want to password-protect and unprotect all worksheets in a workbook in one step because protecting and unprotecting each worksheet individually is a huge nuisance. You also can supply a password so that another user cannot unprotect the worksheet and gain access unless he knows the password. Excel provides protection that you can add to an Excel worksheet by selecting Tools » Protection » Protect Sheet.
0 Comments
Leave a Reply. |