Create Macro in Excel

[DJ]

Is possible to create macro in excel without using VB?

 

[Bob I]

You mean as in "record" a Macro? Have you looked at what's available to
you?

 

[Harlan Grove]

DJ wrote...

Is possible to create macro in excel without using VB?

If you're thinking of Access macros, which aren't VBA, no, Excel
provides nothing comparable. You could create XLM macros in macro
sheets, but you'd be better off using VBA. The macro recorder will
record most actions as VBA code. Have you tried it?

On a different tack, is the issue your macro security settings?

 

[DJ]

No, I have one big excel file which I add a bunch of records to it. I want to
create a formula and everytime I added records, it would be able to do the
math for me.

 

[DJ]

No, I have very little (or no) knowledge VBA. Thanks anyway.

 

[Bob I]

Please see Tools, Options, Calculation for the settings.