Thanks in advance to all who respond.

I have created a workbook (xl 2K) with separate worksheets for each sales
person.
Each sheet is identical to the other (except for name and individual data).
And each sheet contains a performance chart showing their sales.
There are 2 trend lines - the first is linear and the second is
polynomial.
The data is imported from multiple files in the folder.

The importing and charts work great.

On one sheet I have added a spin-button to control the order of the
polynomial
( 2 - 6) and it works great. The code is in the worksheet module.

Question:
Is there a way that the spin-button click event can be made universal
and initiated from the
ThisWorkbook module? My intent is to remove worksheet code from each sales
person sheet and use the code in ThisWorkbook. (the reason is that new
sheets are being created all the time and I would rather not deal with
individual sheet code.)

I am aware that a user-form could do this, but would prefer to avoid this
route.

Please let me know if I am insane or not...

Again - Thanks...

--
steveB

Remove "AYN" from email to respond