Macros & Validation

[John Calder]

Hi

I run Win2k and Excel2K

I have a spread sheet that has some data validation drop down lists. These
work fine.

I also have the following macro in the sheet which is run from a control
button.


Sub CopySheet()

Sheets("Incidents").Select
Sheets("Incidents").Copy
End Sub


The macro copies the worksheet called "Incidents" to a new workbook

The macro works fine.

The problem is that after I run the macro the data validation drop down
boxes in the original worksheet dissappear. If I check the data validation,
the range is still defined, however the ltttle arrow that allows the drop
down list to appear is nowhere to be seen.

If I shut the worksheet down and reopen it the same problem exists. However
if I shut the Excel program down and restart it, everything is back to normal
until I run the macro again. Then I lose the data validation drop down lists
again.

Can anyone help me with this problem?

Any help is much appreciated

John