Hi,

I have a spreadsheet that I am using like a database (I know I should
have written it in access but was told to write it in excel) but the
problem is that if people sort it using either the AZ button or the
options in an autofilter it messes up the data stored on other
worksheets. Can I disable the use of the AZ button and the sort AZ in
the autofilter drop down (I need the drop down for its other
functions). I would be happy at the very least if I could have a pop-
up saying 'are you sure you want to do this?' and giving the option of
cancel.

Thanks in advance.

Matt