Vb Macros are not working

Asked By 10 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by vtech
Best Answer
Best Answer
Answered By 0 points N/A #82912

Vb Macros are not working

qa-featured

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.
  1. Close open projects, click on ToolsàMacroàSecurity.
  2. Under Security, select or click Security Level Tab and choose medium then press OK.
  3. 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 0 points N/A #82913

Vb Macros are not working

qa-featured
  • It seems you would have to set the .XLA to be explicitly opened before it can be used.
  • This is done automatically when we open Excel manually, but when objects are used it opens it using the following command: o Excel.Run("solver. xla!auto_open")
  • Once this is done, your application should start working as expected and the error should also be cleared.
Answered By 0 points N/A #82915

Vb Macros are not working

qa-featured

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

 

Login/Register to Answer

Related Questions