Vb Macros are not working

Asked By Dennie Taylor 10 points N/A Posted on - 07/24/2011

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?

• Status: Open
• Question Views: 1253
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: .NET Programming

Best Answer by vtech

Go To Solution

Best Answer

Best Answer

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.

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.

About vtech

Questions
0

Answers
6

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 07/26/2011
• Question Category: .NET Programming

Answered By jewel uddin 0 points N/A #82913

Vb Macros are not working

• 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.

About jewel uddin

Questions
0

Answers
31

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 07/28/2011
• Question Category: .NET Programming

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

 

About mherboy

Questions
0

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/15/2011
• Question Category: .NET Programming