VBA Excel: set Sensitivity Label as Public

585 Views Asked by At

Good morning, I would like your help. Is there any code with which I can set the sensitivity label as 'Business Use' for every new Excel file I open?

Workbooks.Add
'Define Sensitivity label as 'Public'
ActiveWorkbook.SaveAs fileName:="C:\Users\" & Environ$("username") & "\Desktop\Test " & SR & ".xlsb" _
        , FileFormat:=xlExcel12, CreateBackup:=False

Could you please help me set the sensitivity label as Public?

thank you all !

I found the following code diplay the sensitivity id I guess. I want to change the "GetLabel" to SetLabel I think....

Sub GetSensitivityID()

Dim myLabelInfo As Office.LabelInfo

Set myLabelInfo = ActiveWorkbook.SensitivityLabel.GetLabel()

MsgBox (myLabelInfo.LabelId)

End Sub

0

There are 0 best solutions below