macro and vba tools are disappeared on the excel sheet 2007

[basavarajkh]

Hi

In my excel sheet 2007, macro and vba tools are unvisible. So, how to make them appear on the

sheet.

Thank you in advance

 

[SirJB7]

Hi, Basavaraj K H!

Try this: File, Options, Options Ribbon Customization, right pane, click on to enable Programmer.

Regards!

 

[kuldeepjainesl]

Go to excel options, Check Developer tab, and then only you will be able to see VBA options.


Edit: SirJB7 already guided you in the right direction.

 

[basavarajkh]

Sorry, I am not understood.

Please...,

 

[SirJB7]

Hi, Basavaraj K H!

Follow this steps:

a) close all running instances of Excel

b) open a new Excel session

c) go to the File tab

d) go to Options (penultimate entry)

e) go to Customize Options Ribbon

f) in the right pane, check for Programmer entry and click on it to enable (if disabled)

g) click on Accept

This should make your missing tools visible.

Regards!

 

[Debraj]

Hi, Basavaraj K H!

Just to be more clear..

Can you please re-read the below line

f) in the right pane, check for Programmer entry and click on it to enable (if disabled)



as


f) in the right pane, check for Developer Tab and click on it to enable (if disabled)

or confirm check the below URL and apply as per your EXCEL version..

http://office.microsoft.com/en-us/excel-help/show-the-developer-tab-or-run-in-developer-mode-HA010173052.aspx

http://www.lytebyte.com/wp-content/uploads/2008/03/enable-developer-tab-and-macro-in-excel-2007.jpg

http://excelsemipro.com/wp-content/uploads/2010/11/Ribbon-Dialog-Box.jpg

http://www.dataxstream.com/wp-content/uploads/2009/10/Excel2003_macro_security.png


Regards,

Deb


@ SirJB007..

I got the screenshot here.. and realize where did you get this.."Programmer" Tab..

http://chandoo.org/forums/topic/excel-2007#post-16876


EDIT: Thanks for the catch, Debraj Roy!

 

[Debraj]

Can someone inform spam-catcher to exclude my previous post..


EDIT: hmmm... what he did? let see...


EDIT 2: done... but don't catch your comment... you're not writing in English, are you?

EDIT 2 addendum: ok, I've got it... in Spanish versions it says "Programador" which is "Programmer", if in English versions it says "Developer" it should have said "Desarrollador" in Spanish ones... I apologize for Redmond guys error.


EDIT 3: I don't know why spam catcher detected your previous post... taking a blind shot:

a) there was a link to Microsoft

b) there were more than two links and none from Chandoo

c) the spam bot was sleeping and suddendly awoke