How do I get a macro to run when I have to check workbook out and in on teams.

[ghrek]

Hi

I have a workbook and a macro that im trying to auto run when I either open or close workbook. Ive tried it many times and it not doing it. Believe it something to do with me having to check in and out.

Any Ideas?

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cells.Select
    With Selection.Font
        .Name = "Daytona Condensed"
        .FontStyle = "Regular"
        .Size = 11
        .Strikethrough = False
        .Superscript = False
        .Subscript = False
        .OutlineFont = False
        .Shadow = False
        .Underline = xlUnderlineStyleNone
        .TintAndShade = 0
        .ThemeFont = xlThemeFontNone
    End With
    Range("A5308").Select
    Selection.End(xlUp).Select
    ActiveWindow.SmallScroll Down:=-6
End Sub

 

[Candyman8019]

You mentioned checking in/out in Teams. do you mean SharePoint? Are you opening the sheet in Web view or the Desktop app? Macros don't run in web view.

 

[ghrek]

Sorry yeah sharepoint and using desktop app

 

[Candyman8019]

Are you getting any error message, or just nothing happens?

 

[Candyman8019]

what version of excel are you using? This code seems to work on my system with O365.

 

[ghrek]

Just nothing happening. Pretty sure got O365