Visio 2007 - Unable To Record a Macro

efernandes · June 24, 2010, 11:06:44 AM

Hi,

I Just installed Visio 2007 and I need to create some macros but I am unable to do it because in menu Tools->Macro->"Recor New Macro..." and "Visual Basic Editor Alt+F11" are disabled.

I have check "Enabled all macros..." in Trust Center.

What else do I have to do?

Regards,
Elio Fernandes

Paul Herber · June 24, 2010, 11:14:09 AM

Do you have a document open? Macro recording won't work if there is no open document.

efernandes · June 24, 2010, 11:27:39 AM

I have opened a new blank document.

Paul Herber · June 24, 2010, 01:12:53 PM

In Visio 2003 there was the setting
menu Tools -> Options -> Security
"Enable Microsoft Visual Basic for Applications"
which if unticked greys out the Macro menus

but I cannot find this in Visio 2007.

However, it is a registry setting
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Visio\Application\NoVBA
ensure this is set to 0

efernandes · June 30, 2010, 08:33:37 PM

Hi Paul,

In regedit there is no "NoVBA" in HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Visio\Application.
I can add a new key or value. What should I do?

Regards,
Elio Fernandes

Paul Herber · June 30, 2010, 09:51:15 PM

I'm away from the office at the moment and have no access to Visio (I forgot to bring along the laptop, but that has Visio 2010 so not so much use). There is a setting to make sure that Visio stores all its settings in the registry, I think it's in the Tools -> Options -> Advanced menu. Called "Store all settings in registry" or similar. Tick this, close Visio, restart Visio and close it again. You may now find that NoVBA setting in the registry.

efernandes · July 05, 2010, 03:15:02 PM

Hi Paul,

I can see all the regestry settings now, but I am still unable to record macro because the otpion is unavailable.
It's possible record macros in all versions of Visio 2007 (Standard, Professioal, Enterprise, etc)?

Regards,
Elio

Paul Herber · July 05, 2010, 03:17:18 PM

Quote from: efernandes on July 05, 2010, 03:15:02 PM
It's possible record macros in all versions of Visio 2007 (Standard, Professioal, Enterprise, etc)?

100% sure.

efernandes · July 06, 2010, 08:48:48 AM

Hi Paul,

I just found that some features related with Microsoft Office in Visio 2007 were not installed.
Now I can record macros. Thanks for your help.

Regards,
Elio Fernandes

Paul Herber · July 06, 2010, 10:59:32 AM

Quote from: efernandes on July 06, 2010, 08:48:48 AM
I just found that some features related with Microsoft Office in Visio 2007 were not installed.
Now I can record macros. Thanks for your help.

Ah! Splendid.

neilwarren · October 25, 2011, 02:11:24 PM

I know this is an older post, but I am experiencing the same problem. Do you know what features were missing?

Thanks,
Neil