I have an Excel file with 3 tabs and a menu that can launch a macro. This macro creates a new file with data extracted from the first file (creates statistics).
Now, for various reasons, I will have to put a password to access the macro code, and put a password to use the macro statistics.
The first file must be changed (in the data in the tabs). But I can not add these tabs. But I want the names of the charts in the second file (generated automatically by the macro) that are configurable. So, how to store these names without putting them in sheets?
Bookmarks