MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Enable Macro

  Asked By: Ira    Date: Mar 24    Category: MS Office    Views: 1080

I have Excel 2007. I could not get macro working. I went to Excel
option and check mark on "show Developer tab in the Ribbon" then went
to trust center and use enbale all macro ( not recommended; potentially
dangerous code can run). I click on Developer on tab and Visual Basic,
Macros and Record Macro are dim. I could not click on it. I dont know
what went wrong. I am very new on Macro. I want to use it for phone
number. I have a long list of phone number. I need to run macro to
check each area code on phone number that will tell which state they
are from. For an example (386) XXX-XXXX which is in Florida. It will
put FL on next column. How do we do that?



1 Answer Found

Answer #1    Answered By: Aamanee Khan     Answered On: Mar 24

Security has been beefed up quite a bit with the latest release. You might
want to check with your IT department if you are allowed to change the
default setting (some IT departments set up policies that prevent you from
changing the defaults).

If no luck there, a Microsoft support group will be a good option as well.

In terms of your second question, there is no need to use macros for what
you want to do.
On a separate sheet, define two columns with code and abbreviation for
state. Now, using VLOOKUP, process the long list against your new table.
Your formula will look something like this:
A1 = (386) XXX-XXXX
B1 = characters 2 to 4 only (display is 386)
C1 = =VLOOKUP(B1, Sheet2!A2:B51,2, FALSE)

Didn't find what you were looking for? Find more on Enable Macro Or get search suggestion and latest updates.