Security Considerations

Because you don't particularly want your users modifying the Settings worksheet on a whim, normally this worksheet is very hidden (xlVeryHidden—so hidden it doesn't show up when you select Format > Sheet > Unhide). Although I haven' t done so here, you could extend the final product to use a protection scheme on this worksheet as well so that it can't be changed without using a password.

While I'm on the subject, this method of storing data is not inherently secure. Ninety-nine percent of general Excel users won't have a clue as to how this functionality is implemented or that the Settings worksheet even exists. To further prevent the Settings worksheet from being "discovered" by curious users, you should lock the VBA project so that you can't stumble across it in the code or as one of the Microsoft Excel objects in the Project window.

Even when you take these measures, it's still possible for people knowledgeable about VBA to discover the Settings worksheet. Once they know that a worksheet exists, anyone can at least read its contents by setting up formulas that link to that worksheet from another worksheet. Therefore, don't put anything on the Settings worksheet that you can't take any chances about other people discovering. That said, it's still highly unlikely that most people will even know it exists, so for the purposes for which you're planning on using it, I don't think this is a problem. It's certainly less visible than INI files that can be opened and inspected using Notepad.

0 0

Post a comment