Hello! Thank you all who answered my question yesterday. I really
appreicated your suggestions.

The next question I have is how to move a macro out of my 'Personal'
excel worksheet (stored on my local desktop) to a specific worksheet
that can be on the network for others to use? Also this spreadsheet on
the network needs to open each time someone opens an excel file in a
particular folder.

Thanks very much,
Deanna