Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
First Value in Sorted Column is Not Sorted Properly | Excel Discussion (Misc queries) | |||
Sorted Data | Excel Worksheet Functions | |||
transfering data in another column entering more sorted data | Excel Worksheet Functions | |||
How do I stop column headers from being sorted in a row? | Excel Discussion (Misc queries) | |||
Stop heading row being sorted (Excel 2003) | Excel Discussion (Misc queries) |