Macro options in Excell 2003
 

I have a workbook that has 4 worksheets in the workbook. On Worksheet 1
there is a list of products that we sell. On Worksheet 2 is a contract that
customers will sign, that will have all information selected on Worksheet 1.
Worksheet 3 Has all the prices.

Our salesmen fill out worksheet 1 of all the items needed to be sold to the
customer. Worksheet 2 looks at those items and has a macro built that will
pull the description of the product over and then calculates the price
depending on the number of items sold and the price per item on Worksheet 3.
Worksheet 2 then calculates a total price. Worksheet 1 has a cell that
looks for the total price from worksheet 2.

The macro is built so that it will pull the items from worksheet 1 and place
them in specific spots on worksheet 2, worksheet 2 then calculates the price
and then imputs that price on worksheet 1. Worksheet 1 is given to the
customer as a quote.

the problem i am having is worksheet 2 does not perform the macro until it
is viewed, which is messing up the price on worksheet 1.

My question is: Is there anyway to tell the workbook or worksheet to
perform the macro without viewing worksheet 2?

Macro options in Excell 2003
 

You probably need this at the top of the sub:
Sheets("Sheet1").Activate

I use this too because some of my sheets may be xlSheetVeryHidden
Sheets("Sheet1").Visible = True
Sheets("Sheet1").Activate

Regards,
Ryan---


--
RyGuy


"Joshua" wrote:

I have a workbook that has 4 worksheets in the workbook. On Worksheet 1
there is a list of products that we sell. On Worksheet 2 is a contract that
customers will sign, that will have all information selected on Worksheet 1.
Worksheet 3 Has all the prices.

Our salesmen fill out worksheet 1 of all the items needed to be sold to the
customer. Worksheet 2 looks at those items and has a macro built that will
pull the description of the product over and then calculates the price
depending on the number of items sold and the price per item on Worksheet 3.
Worksheet 2 then calculates a total price. Worksheet 1 has a cell that
looks for the total price from worksheet 2.

The macro is built so that it will pull the items from worksheet 1 and place
them in specific spots on worksheet 2, worksheet 2 then calculates the price
and then imputs that price on worksheet 1. Worksheet 1 is given to the
customer as a quote.

the problem i am having is worksheet 2 does not perform the macro until it
is viewed, which is messing up the price on worksheet 1.

My question is: Is there anyway to tell the workbook or worksheet to
perform the macro without viewing worksheet 2?