Hello!
I’m having a problem with my VB macros. When I was programming at the office, everything was working just fine. Later, I decided to get a copy of VB from my office so I can work with it from home. After installing the program, I opened the project I was working on and got this error:
The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros.
Why aren’t my macros working in my home computer?
Answered By
vtech
0 points
N/A
#82912
Vb Macros are not working
Hello Dennie Taylor!
-
Possibly the reason that you are getting the message, “the Macros in this project are disabled” in your home computer is because the security settings for macros are set too high.
-
Try to change or reset the security level.
-
Close open projects, click on ToolsàMacroàSecurity.
-
Under Security, select or click Security Level Tab and choose medium then press OK.
-
Go back and open the project; if a window pops up asking you if you want to “enable or disable Macros", simply click on Enable Macros.
I hope this will be able to help resolve your issue.
Let me know how it goes.
Answered By
mherboy
5 points
N/A
#82915
Vb Macros are not working
If you are using Excel 2000 or newer, VBA may be disabled. Before you can start using VBA, you need to enable macros on the Security dialog box. From the application menu, choose Tools, Macro, Security. Set the macro security level to medium. This will allow VBA macros to run, but you will have to explicitly enable them when you open Excel.
Read More: http://wiki.imacros.net/How_to_enable_VBA_macros
