topic RE: Excel sensitivity label in Product Forum

Excel sensitivity label

santosb — Wed, 20 Apr 2022 17:29:00 GMT

Hello, I'm testing the Excel sensitivity label functionality, that requires to select a label before interacting with the workbook, and have not been able yet to figure out how to select a label automatically. Does anybody knows how to manage this using Excel VBO? Thanks in advance

------------------------------
Beatriz Santos
P2P Lead Europe
CHEP
Europe/Madrid
------------------------------

RE: Excel sensitivity label

ewilson — Thu, 21 Apr 2022 14:39:00 GMT

@Beatriz Santos,

Sensitivity Labels are not currently supported in the VBO.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Excel sensitivity label

ManpreetKaur1 — Fri, 22 Apr 2022 17:36:00 GMT

Hi @Beatriz Santos,

Did you try code stage to achieve the functionality?

------------------------------
Manpreet Kaur Manager
Manager
Deloitte
------------------------------

RE: Excel sensitivity label

PawanPanjwani — Thu, 18 May 2023 12:26:00 GMT

Hi All,

I have came across a requirement where I have to change the Excel file's Sensitivity label to Confidential before saving the file. Now I know the Excel VBA Code of it, however I was not able to make it workable via code stage. Can anyone help me on this?
--------------------------------------------------------------------------------------------------------------------------------
Here is the VBA Code:

Sub SetSensitivityLabelConfidential()

Dim myLabelInfo As Office.LabelInfo
Dim Context As Variant
Dim objWorkbook As Workbook
Dim SConfidential As String

Set objWorkbook = ActiveWorkbook
Set myLabelInfo = objWorkbook.SensitivityLabel.CreateLabelInfo()
Set Context = CreateObject("Scripting.Dictionary")

With myLabelInfo
.AssignmentMethod = MsoAssignmentMethod.PRIVILEGED '1
.ContentBits = 4
.IsEnabled = True
.Justification = "Write Your Reason"
.LabelId = "Your Organization alpha numberic code for Confidential type"
.LabelName = "Confidential"
.SetDate = Now()
End With

objWorkbook.SensitivityLabel.SetLabel myLabelInfo, Context

End Sub

--------------------------------------------------------------------------------

Thanks & Regards,
Pawan Panjwani

------------------------------
Pawan Panjwani
------------------------------

RE: Excel sensitivity label

PawanPanjwani — Wed, 24 May 2023 11:37:00 GMT

Hi Members,

Can any one help me with the above issue.

Thanks & Regards,
Pawan Panjwani

------------------------------
Pawan Panjwani
------------------------------

RE: Excel sensitivity label

acatalano — Tue, 18 Jul 2023 16:41:00 GMT

Did you find a solution? @PawanPanjwani1

------------------------------
Agustin Rodolfo Catalano
Computing Engineering
Santander Argentina
America/Argentina/Buenos_Aires
------------------------------

RE: Excel sensitivity label

PawanPanjwani — Wed, 19 Jul 2023 13:38:00 GMT

Yes Agustin, got the solution.

------------------------------
Pawan Panjwani
------------------------------

RE: Excel sensitivity label

acatalano — Wed, 19 Jul 2023 18:59:00 GMT

could you tell me how you did it? @PawanPanjwani1

------------------------------
Agustin Rodolfo Catalano
Computing Engineering
Santander Argentina
America/Argentina/Buenos_Aires
------------------------------