Help with command buttons
 

Good day. I am using Excel 2002 and Windows XP Pro. I have a worksheet that
controls my product pricing. The data input to this worksheet is an export
from QuickBooks directly into a new worksheet in an existing workbook.

The process is as follows;
1. export from QuickBooks into a new worksheet in the existing workbook.
2. run a macro in the workbook that copies all of the formulas from the
existing worksheet to the new worksheet. This is done because QuickBooks is
not able to formulate the pricing as I want it.
3. the existing worksheet is deleted.
4. the new worksheet is renamed.

The above process all works well and has worked well for 5 years. Today I
tried to add 2 command buttons to the worksheet that would run macros to sort
the data, one by Item and one by Description. In an earlier question to the
group, I was able to isolate a problem caused by the fact that I was running
ActiveX Controls instead of Toolbox Controls.

Everything was working until I exported a new price list from QuickBooks.
The command buttons did not get copied from the existing worksheet to the new
worksheet. What did I miss?

Thanks to those who respond. Danno...

Good day again. For those of you who read my problem and thought to
yourselves "another beginner", sometimes we back ourselves into corners and
can't see the obvious.

Yes, I figured it out. My copy routine needed some help. All is working now.
Thanks, Danno...

"Danno" wrote:

Good day. I am using Excel 2002 and Windows XP Pro. I have a worksheet that
controls my product pricing. The data input to this worksheet is an export
from QuickBooks directly into a new worksheet in an existing workbook.

The process is as follows;
1. export from QuickBooks into a new worksheet in the existing workbook.
2. run a macro in the workbook that copies all of the formulas from the
existing worksheet to the new worksheet. This is done because QuickBooks is
not able to formulate the pricing as I want it.
3. the existing worksheet is deleted.
4. the new worksheet is renamed.

The above process all works well and has worked well for 5 years. Today I
tried to add 2 command buttons to the worksheet that would run macros to sort
the data, one by Item and one by Description. In an earlier question to the
group, I was able to isolate a problem caused by the fact that I was running
ActiveX Controls instead of Toolbox Controls.

Everything was working until I exported a new price list from QuickBooks.
The command buttons did not get copied from the existing worksheet to the new
worksheet. What did I miss?

Thanks to those who respond. Danno...