Ask Experts Questions for FREE Help !
Ask
    Satish217's Avatar
    Satish217 Posts: 1, Reputation: 1
    New Member
     
    #1

    Sep 7, 2010, 04:23 AM
    How to activate macros in excel 2007?
    Actually I am trying to activate the macros in my PC. But the Macro setting option is not allowing me to do that as it turned grey and is inactive I can not click on any option. Can anyone please help me to activate the macros?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Sep 7, 2010, 07:30 AM

    Try opening or saving the file in question as a .xlsm file. Excel 2007 introduced macros by file type.

    If your doc is a .xlsx file, it will never have/allow macros.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Macros for sequential numbering in multiple worksheets in excel with [ 1 Answers ]

I have a workbook with worksheets for each day of the month. I need to subtract one day to = equal number of days left in the month. Ex(May 1st there are 31 days left in month, May 2nd, worksheet two, there are 30 days left in the month, and so on and so forth.) Is there a way to have these days...

Excel Linking & Macros [ 1 Answers ]

I need to create a summary sheet from input into different worksheets. Original sheet is the input sheet, summary will automatically pull from Original into summary from just certain cells. The problem is, the original worksheet changes, the person inputting uses the last sheet he created and...

Run Macros In Excel [ 1 Answers ]

Hi, I have created a few macros in an Excel spreadsheet, but I had to click "RUN" Macro every time in order for the data to update. If possible, can you please show me if there is a way for me to update the data and it runs automatically. Thanks for any helps.


View more questions Search