Forum Discussion

dbp428's avatar
dbp428
Copper Contributor
Apr 07, 2024

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

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. I...
excel
Macros and VBA
Office Scripts
SophieT's avatar
SophieT
Copper Contributor
Apr 07, 2024

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.

 

  • dbp428's avatar
    dbp428
    Copper Contributor
    Apr 07, 2024
    Thanks for this. I did find it and also how to click on the list to open the VBA code window.
  • SophieT's avatar
    SophieT
    Copper Contributor
    Apr 07, 2024

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

     

    • dbp428's avatar
      dbp428
      Copper Contributor
      Apr 07, 2024
      Yes I have this turned on thank you... I solved it

Resources