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
- Best option to refresh a single query using VBA
- Repeat VBA Code to run for another cell in the same sheet
- Create a folder and sub folder in Excel VBA
- How to loop in excel without VBA or macros?
- Configure default number format to 0 decimal places for new/existing workbooks in Excel 365 ProPlus?
- Delete objects and replace spaces left after that with symbols in black (color)
- EXCEL randbetween- text representation - clarification
- How do I access a historical weather API from open-meteo in Excel using VBA?
- Finding the correct remaining customer term with a given goods volume
- Speeding Up Index-Match for Large Dataset
- How to get current time in VBA as string? Ex. 7:38 PM, I want "073800"
- Data cleanup for large data set
- Adding a newline character within a cell (CSV)
- Excel SORT Function in Conjunction With UNIQUE, TOROW & VSTACK
- Hide and Unhide Rows via Single Button
- Xlwings Excel and Windows Task Scheduler issues
- Put borders below all the rows with the last date value in a date series
- Issue with IF sentence containing AND & OR functions
- Unprotect an Excel file programmatically
- Complicated xlookup across two sheets with multiple criteria
- Sumif times (datetime format) are greater than 22:30
- How to loop concatenate separately, groups of rows with VBA?
- SumProduct over sets of cells (not contiguous)
- Adding a "0" to the beginning of a 4 digit excel cell to make it a zip code.
- Can't unprotect an excel worksheet in Workbook_BeforeSave
- Change formula to a function that evaluates the starting formula
- Chart range based on the value in a cell
- Changing cell colour using VBA in Excel
- How to color excel cells with specific values in dataframe Python
- Talend import, transform a raw file and export to CSV