Recording and saving a macro as VBA code instead of Office script

Question

I believe when I enrolled in Insider and got updates defaulting to Office scripts? So now creating a macro by clicking the Developer Menu and Record Macro it's creating an Office script by default. Is there a way to create VBA code by default which then should be saved in a new module like it has done in the past? Hope this makes sense.

TIA

Doug

sophiet · Answer

Is this in Excel? If so, then in the Developer tab there should be a button for visual basic. the Record Macro is a wizard to help you create a macro w/o coding. This would be the same in Office & Power Point.

sophiet · Answer

This is my Trust Center Settings for Macro Settings... when i click on record macro it saves it as vba:&nbsp;

dbp428 · Answer

Thanks for this. I did find it and also how to click on the list to open the VBA code window.

dbp428 · Answer

Yes I have this turned on thank you... I solved it

Forum Discussion

Recording and saving a macro as VBA code instead of Office script

Share

Resources