Hi:

I am very new to Excel VBA programming, I have few questions for VBA
Expert.

I have an Excel produced by an order entry application that has
multiple worksheet, each sheet has the same layout except the data is
different (i.e. customer 1 order info on worksheet1, Customer 2 order
info on worksheet2, etc ).

This application is installed on the network and each user has access
to generating the Excel Report.

I need to create an Excel Macro that is independent of the Excel
Report, where this macro can be located on the network drive and when
user have the Excel report loaded, he just need to locate the macro on
the network drive and run it (Is this possible?)

Here's what the macro has to do:
Go through each worksheet,
1. Hide a number of unnecessary columns and rows. (same for each
sheet)
2. Remove some default column heading (same for each sheet)
3. Perform some additional misc stuff. (same for each sheet)
4. On the daily basis, customer order info changes and this macro
should be dynamic and not static, so when order info changes, it
should still work.


Here's my psuto code approach, I would like some expert opinion to see
if my approach is in the right way.

Steps:
1. Create a macro/VBA project independent of the excel workbook (I
don't know how to do this)
2. Within the macro, I first determine how many sheet are there. (I
know how to do this )
3. I scan through each sheet and performing the following I do the
hiding of columns and rows and removing coloring. (I know how to do
this part)
4. Deploy this macro on network and enable other user to run this
macro. (I don't know how to do this)

For step 1 and 4, can any expert give me some hint on how to achive
this?

Thank you

Peter