data validation format loss
 

I have a template with drop down boxes.
Access opens template, runs a macro, saves template as new filename.
Drop down boxes are no longer in my newly saved file.

If I open template and run macro and save to new filename all in Excel
everything is OK, any thoughts

--
cbillings00
-----------------------------------------------------------------------
cbillings001's Profile: http://www.excelforum.com/member.php...fo&userid=1659
View this thread: http://www.excelforum.com/showthread.php?threadid=31456