I've already gotten a lot of help here with creating this series of
worksheets that will soon be distributed to some "unsophisticated"
end-users. Some of the setting up I'm doing in these sheets involves
macros that determine where the filter range is on each sheet (topic of
other threads here) and does a few other things to some of the
worksheets. I'm wondering if those of you with more experience with
slightly more complex sheets like these being distributed to those
"unsophisticated" end-users can give me some direction. Should I just
run the macro that sets up the sheets before I send the protected
worksheets out, and hope no one finds a way to mess them up, or should
I build the set-up macro into the sheet so it runs when the sheet is
opened, resetting the filter range each time in case it somehow
changes? My inclination is to go with the KISS principle, and keep the
macro here, not in the sent-out version. But I'm open to differing
ideas.