I have written some code that automatically inserts a new sheet into a user's open workbook, based on an .xltx template.
Works fine.
I would now like to store some hidden information along with that new sheet - just some metadata that will be used to process it later on. I could do this by also inserting a hidden sheet into the workbook, but this decoupling could cause trouble later (for instance if the user copy-pasted this sheet into a brand new workbook).
Is there any area within a sheet, or some sort of excel hack, that would allow me to store some key value pairs with the sheet, but without the user needing to know about it?
Thanks in advance.
(ps - am currently using vsto/excel07, but am happy to panelbeat something else)
KevinT
Bookmarks