VB in Microsoft 365 Online

[Tgpitch16]

I added the following VB code when a user opens a particular file, it will automatically pop up with a message, then prompt the user to Save As a copy. The goal is to preserve the original contents of the file. All of the audience will be using the online version of Microsoft 365 Excel. Is there a way to accomplish this?

Private Sub Workbook_Open()
' Display a message box explaining to the user to Save As a new document
MsgBox "Before you begin, you will be prompted to Save As a new file. Name this file the date of your store visit. ", vbInformation, "Save As Prompt"

' Prompt the user with the Save As dialog box
Application.Dialogs(xlDialogSaveAs).Show
End Sub

 

[LegendaryAxe]

Excel Online doesn't support VBA. You can write macros with Office Scripts, but there's no event handling feature, so any scripts would have to be run manually. So you would probably have to look into Power Automate for this (which I don't know too much about).

Differences between Office Scripts and VBA macros - Office Scripts

Office Scripts don't support Excel-level events. Scripts are only run when a user manually starts them or when a Power Automate flow calls the script.