"Macros" and "Visual Basic" in developer tab are locked and not clickable

[fitkhan]

Hi,
Thanks for checking my thread. I want to add a macro to a sheet but the "Macros" and "Visual Basic" in the developer tab are locked, i.e not clickable. How can i make them work? attached is a screen sheet of my excel sheet...

I am using Office 2013.

thanks a lot

[:) Sixthsense :)]

What happens if you press Alt+F11?

If VBA window does not appear then it means that VBA is not installed while installing MS-Office. Re-install Ms-Office by including/selecting the VBA part also

[fitkhan]

What happens if you press Alt+F11?

If VBA window does not appear then it means that VBA is not installed while installing MS-Office. Re-install Ms-Office by including/selecting the VBA part also

Thanks a lot.. Let me re-install it and will come back soon

[Richard Buttrey]

Hi,

Have you recently had an upgrade and were you able to build macros previously?
If so I believe network administrators can make macros unavailable by default. Have you checked with them?

[fitkhan]

What happens if you press Alt+F11?

If VBA window does not appear then it means that VBA is not installed while installing MS-Office. Re-install Ms-Office by including/selecting the VBA part also

Thanks a lot.. Let me re-install it and will come back soon

[fitkhan]

Hi,

Have you recently had an upgrade and were you able to build macros previously?
If so I believe network administrators can make macros unavailable by default. Have you checked with them?

Hi, I installed new windows and for the first time i am using 2013 version and am using macros for the first time on this window. The reinstall is almost completed. Let me see the results

[fitkhan]

Thanks a lot. Reinstall worked.

[:) Sixthsense :)]

Glad you fixed it and thanks for the feedback

[zitno]

amazing ;D it works great ... thanks a lot man :D ... great job