Exel VBA sensitivityLabel not working

[AKEBOAG]

Hi

Set myLabelInfo = ActiveWorkbook.sensitivityLabel.GetLabel()
=> produces error "Method 'SensitivityLabel' of object '_Workbook' failed
I think because class is not registered.
Which reference is needed in VBA available references so set command is working.

Regards and thank you

Alois

 

[Jeffrey Mahoney]

Please see:
Change Sensitivity Label Programatically

 

[AKEBOAG]

Please see:
Change Sensitivity Label Programatically

Hi Jeffrey

I was using exactly your code example:

Sub GetSensitivityID()
Dim myLabelInfo As Office.LabelInfo

Set myLabelInfo = ActiveWorkbook.sensitivityLabel.GetLabel()
Debug.Print myLabelInfo.LabelId

End Sub

and the bold part produces the mentioned error.

I think the VBA reference is missing but I do not know which one.

Regards

Alois

 

[Jeffrey Mahoney]

These are the references I currently have loaded and it works for me

 

[AKEBOAG]

These are the references I currently have loaded and it works for me

View attachment 112097

Hi Jeffrey

Thank you very much for this screenshot!

Having the same references does not solve the problem with me so it must be a configuration of the software installation/configuration.

Regards Alois

 

[Jeffrey Mahoney]

So, you have a workbook open? Have you chosen a sensitivity level for it? I'm grasping at straws.