Stop Data being sorted
 

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

Stop Data being sorted
 

I use Excel as a database program for a couple of applications at
work, and I can sort the raw data without causing any problems. I
make liberal use of VLOOKUP to extract the data I need. Perhaps
something like that may work for you?

Mark Lincoln

On Sep 10, 11:08 am, wrote:
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

Stop Data being sorted
 

Thanks for the suggestion but it still doesn't solve the problem of
using the sort button.

What I need is a VBA script that picks up on an action of clicking on
a button and also for the autofilters (but I may be able to use the on
change event for that).

Any suggestions?

Thanks

Matt


On 10 Sep, 18:10, Mark Lincoln wrote:
I use Excel as a database program for a couple of applications at
work, and I can sort the raw data without causing any problems. I
make liberal use of VLOOKUP to extract the data I need. Perhaps
something like that may work for you?

Mark Lincoln

On Sep 10, 11:08 am, wrote:



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- Hide quoted text -

- Show quoted text -