copy paste sheet with validation

[Preeti]

Hi,

I have a write protected sheet with various validated drop-down boxes.
I have to use this format in a macro code procedure that automatically
fills up some of the non drop-down box fields.

I copy-pasted the sheet into a new sheet to run the code..it works
perfectly..except after the code is run..the values in the drop down
boxes dissapear. The drop down boxes with the validated values have to
stay put..but dont!!

What should i do?

Any suggestions?

 

[JulieD]

Hi

if you'll like to post your code, we'll see if we can spot why this is
occuring - also what version of excel are you using?

Cheers
JulieD