Any reason for posting substantially the same question 9 minutes later?


"alexm999 " wrote in message
...
I just made 31 macro and they all work perfectly.
Now my boss asked me to create 5 worksheets (for 5 stores) and make the
macro's work on each worksheet individually or worksheet specific.

Currently when i try to change the macro in one worksheet, it changes
the macro for all the worksheets...

I need to make these macros worksheet specific..

If I cannot make it worksheet specific, then Can I add an IF statement
that will tell the code that if you're in the 101-JAN04 worksheet, then
use all the information from the c:\UDC\101 directory?

HELP!


---
Message posted from http://www.ExcelForum.com/