Make sure that you save the password somewhere that you will remember. In the VBE editor go to 'Tools/VBAProject Properties/Protection'. Password Protecting the codeĪs an Excel-VBA Developer you might want to protect your code so that nobody else may modify it.

If nothing looks suspicious close the workbook and re-open it enabling the macros. You can go to the Visual Basic Editor to take a look at the macros. You can look at the workbook but the VBA procedures (macros) are not operational. If you know the origin of the file you may enable the macros if not click on 'Disable Macros' and you are fully protected. Tell him how to change his level of security by going to the 'Developer' ribbon, clicking on 'Macro Security', selecting 'Macro Settings and checking the second level 'Disable all Macros with Notification' andįrom then on each time you open a workbook that contains macros a temporary status bar appears above the grid in Excel:Ĭlick on 'Options' and the following dialog window will appear.Īdopt the same attitude as you have with documents attached to Emails. If you send a workbook with macros to a colleague and he can not get them to work it is probably because his security setting is at 'High'. Special note for users of Excel 2007: See how to install the Visual Basic Editor from your Office CD and set the security level of your Excel. Note 2: If you are using Excel 1997 to 2006 see lesson 10 here The setting suggested here is totally safe and you will not make your computer vulnerable to any virus.

Tell your colleagues about it specially if you want to send them Excel workbooks with macros. Note 1: You will change the security setting one single time. Lesson 10 on Excel macros (VBA): VBA Macros Security and Protection in Excel (Excel 2007, 20) Here is a sample of what you will find in lesson 10 of the downloadable Tutorial on Excel macros

Disable macros in excel 2007