excelsecuritydocument
What are Excel labels called and how are they stored?
My company recently implemented this as a requirement before saving a document:
In this case, the options are:
But I'm guessing that's specific to my company, not an Excel thing. I could be wrong.
I want to be able to access this via all of the usual suspects (VBA, Interop, EPPlus, ClosedXML) and some unusual suspects (Dev Express) but don't really know what it's called. When I search for Excel Label, I get lots of stuff thats... not this.
What is this object/property called? Bonus: Snippet of how to access via VBA?
Solution
That looks like a "Sensitivity Label" - mandatory by IT policy. See Microsoft Learn: Sensitivity Labels
I found some useful VBA at MrExcel
- Combined two arrays and the result returned has an empty key and value
- VBA: ListBox Change event firing twice
- Excel VBA offset without activating the cell
- How to have instructional text in Excel?
- How to copy a range to several worksheets by using a list of worksheets to copy to
- Excel's fullname property with OneDrive
- Why I can't compare two dates using comparison symbols in Excel?
- If certain columns are empty within a range, delete entire row (Excel macro)
- Is it possible to create a dymamic array which sums different columns depending on row?
- PowerPivot extract text after different characters
- Merging columns by looping
- Using VBA to copy and paste values into new workbooks but it's hardcoding original workbook at end of process
- Copying data into a worksheet when the destination has hidden rows
- Is it possible disable the "Go to location" feature when co-authoring in excel?
- writing multiple data frames into the same excel file in R
- XLOOKUP with flexible column for return_array and lookup_array
- When Converting excel to csv for empty cells quotes not coming
- Error in including wxAutoExcel in wxWidgets project
- Excel cell not updated correctly
- Convert Range to a table
- Convert number in excel to M or B
- Excel LET Formula Results in #CALC! Error When Applying a Filter
- Save excel file using savefiledialog class in C#
- Excel right click add menu item issue
- Excel, generate a list of names depending on row and column values of another sheet
- Ignore missing columns in pandas read_excel usecols
- When does Excel surround sheet names with single quotes in workbook.xml (or other xml) files?
- getting sheet names from openpyxl
- Counting number of unique values in one column if data in a 2nd column matches anything in a 3rd column
- How to add more than 255 characters in a data validation in xlsxwriter Python