Tuesday, June 28, 2011

How to Protect Macros in Excel 2003


1. Access the Excel 2003 workbook that contains the macro you need to protect. Click the 'Tools' menu and select 'Macros.'
2. Click 'Visual Basic Editor.' Click the 'Tools' option and then select 'VBAProject Properties.'
3. Navigate to the 'Protection' tab. Click the check box labeled 'Lock project from viewing.'
4. Type the password you want to use for the macro in the text box. Press 'Tab' and then type the password again in the second text box.
5. Click 'OK' and then save your Excel workbook.

Blogger news