Allow custom user data / meta data to be stored in the properties of a sheet.
Often when developing Macro's that operate on a worksheet, one needs to store / access worksheet variables that are either:
- visible on the sheet or
- saved in another hidden sheet.
It may be preferred by a Developer if custom meta data could be appended to the sheet properties. This will allow for custom sheet properties to be attached to a sheet rather than referenced from a hidden master sheet.
I appreciate that there may be performance considerations for those people who would like to have a customisable sheet property attribute, if so, it could be controlled by having a global option that turns this feature on or off.
Personally, I think this solution would be welcome by Developers who code in any language as it will be easier and elegant to ensure new sheets inserted into a worksheet have the appropriate custom settings whereas modifying the typical master hidden sheet can be tedious and extremely verbose by comparison.
There are some other ideas here that mention information and sheets, but they do not offer much on the implementation which is why I have posted this new suggestion.