Shoot...I need to get in the practice of stating all my restrictions on these, too. Because the ultimate template will actually be launched from another program that gets a little finicky, I am restricted from using anything that activates upon open of the worksheet, as it appears this one does. I'm still testing whether "on activate" of a particular worksheet will work, but I doubt it will. (I've heard that "on modification" of a certain cell is possible, but I can't find the way to write that, and I'm not certain it would work in this instance anyway; I understand that requires an active modification of a cell, which this would not be.)
Bookmarks