I am working on an excel database type file in which the master sheet is
used as data entry form and the values are stored in other sheets
designated for the particular month in the respective columns(one
column for one day)
Master sheet date is changed by calendar control and the calendar value
is used to get the name of the database sheet and the column.(December
2005, selected column etc)
After entering the values in the master sheet, the user either presses
a macro button named store or a toolbar button also named store.
User can also retrieve data by changing the date to required and
pressing a button named retrieve.
This is where the trouble starts! *If the user changes the date and
presses store instead of pressing retrieve, then the old data which is
already there in the database is lost!*
Is there anyway to disable the store button using the worksheet change
event, i.e., if the cell containing date is changed, the store button
should be disabled temporarily so that user can not by mistake click
it?
Hope I have explained my case clearly


--
lotus
------------------------------------------------------------------------
lotus's Profile: http://www.excelforum.com/member.php...o&userid=23759
View this thread: http://www.excelforum.com/showthread...hreadid=493216