I have 2 worksheets, A, & B. I have ControlButtons 1,2,3&4 that work as
follows:

CB1 is located on A. It loads external data files into B
CB2 is located on B. It collates and massages the data in B and transfers a
copy of it into A
CB3 is located on A. It further analyzes the data
CB4 is located on A and creates a report

Everything above works perfectly.

I'd like to combine the button functions for 1, 2 & 3, but all the trials
I've run have generated 1004 errors. A previous question to the forum gave
me an answer that seems to work, but is really a lot of effort to implement,
and will be a bigger problem as I move forward with this application.

Can I have your comments on the following approaches:
1. Could I create a form that has all the buttons on it, that isn't
associated with the worksheets? (ie, in a module). If so, can it be
semi-transparent?
2. Can I eliminate the buttons and add the functions to to the menu?
3. Can I use an external module to call the function from CB2 and CB3 from
CB1?

Which is most likely to be robust and easy to implement?

Thanks,

Jim Berglund