Ask Experts Questions for FREE Help !
Ask
    Wonder84lalala's Avatar
    Wonder84lalala Posts: 41, Reputation: 1
    Junior Member
     
    #1

    Dec 28, 2007, 09:42 AM
    Run Macros In Excel
    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.
    donf's Avatar
    donf Posts: 5,679, Reputation: 582
    Printers & Electronics Expert
     
    #2

    Dec 28, 2007, 10:12 AM
    I haven't played with Excel in quite sometime, but I believe that when you are setting up the macro you tell Excel whether the macro is an on demand macro or an automatic macro that opes and runs when the spreadsheet is opened.

    I've got to scoot out and take my granddaughter to lunch but after that, I'll take a look at my version of excel and see what's going on.

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!

Ms excel [ 1 Answers ]

Can you give me the meaning of cell adverg

MS Excel [ 2 Answers ]

I am modifying a payroll spreadsheet that was developed in MS Excel. The hours worked by each employee have their own row; each cell represents the hours worked on that particular day. I need to isolate ONLY the amount greater than eight hours (for overtime) and sum those quantities at the end of...

Excel [ 2 Answers ]

:rolleyes: I try to use excel to print an invoice, how can I put an invoice number that will auto upadate the next time I use the file?

Excel help [ 1 Answers ]

I am using excel to record some data and I have it setup to do some math based on the info that I put into certain cells. Now what I am wondering is am I able to setup the sheet so that it will prompt me for the 4 pieces of data that I want to enter and then place those in the proper cells and then...


View more questions Search