Hi,

I have a peculiar problem, when I run a macro I wrote the buttons o
the sheet disappear, some formulae turn to values and the little dro
down buttons on the cells where form validation (unde
DataValidationList) is supposed to happen disappaears too.

This happens especially when I break the code to debug etc.

The macro is quite simple, it just autofilters the sheet looking fo
matches on certain columns, and then sums up certain fields int
variables and stores the result on another sheet.

Any ideas what might be going wrong? I am getting tired of replacin
the buttons and stuff.

Thanks for the help

--
lithium8
-----------------------------------------------------------------------
lithium81's Profile: http://www.excelforum.com/member.php...fo&userid=2946
View this thread: http://www.excelforum.com/showthread.php?threadid=49170