That the XLA file generates spreadsheets and that the spreadsheets need to
have different sets of values was unknown before (or at least I missed it).
But anyway, given your description below, all your points are valid. Storing
the values in a hidden sheet is a very simple approach that will not work
well in a scenario such as yours. Personally, I would prefer a file-based
approach in a scenario like this, either XML or INI.

By the way, a sheet has 3 "visibility" values: Visible, Hidden, and Very
Hidden. A "Very Hidden" sheet is visible only through the VBA IDE. A user
wouldn't be able to unhide it.



"syswizard" wrote:

On Mar 8, 8:12 am, Vergel Adriano
wrote:
How about placing them in a hidden sheet in the workbook itself?
That's OK, but what if they unhide the sheet ? Also, consider the fact
that most of the code will be in an XLA file and that multiple XLS
files will be created. WIth your approach, I would need to copy the
hidden sheet every time a new XLS file is created. Finally, what
happens if the first spreadsheet needs to use any changed values which
are in the latest spreadsheet.
Your approach is good if I need versioning of the values; terrible if
I need a central and consistent source of the values.