I can't see VBA and Micro option in developer menu in excel program.What can I do?
Last edited by ahmadi2010; 10-29-2010 at 11:35 AM.
Do you mean the Developer tab is not visible, or that those buttons are not on it (they should be on the left hand side)?
I mean that those buttons are not on it on the left hand side
Is this true for all workbooks, or just one? If it's all of them, do you have any add-ins loaded? Do you have VBA installed?
yes it's true for all workbooks.No I don't have any add-ins loaded. I have only installed Microsoft office 2007.
Did you do a full installation including VBA? Can you record macros?
Thank you very much for quick responce.
I do installation again. now I don't have Developer tab, but on the view tab on the right hand side,I can see micro (containing record ,. . . . ) but I can't open VBA .
How can I add Developer tab?
Office button, Excel Options, then check the Show Developer Tab option in the Popular section.
Can you record macros? Does Alt+f11 not work?
yes, now it works correctly.
thank you very much.
Glad to help.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Ok ,
Thank you again
Last edited by ahmadi2010; 10-29-2010 at 11:34 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks