| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 macro to warn before sorting
I have a big Excel table and many users.
If a user select a column and start sorting I want a message to warn the user he shouldn't select a column and stop de sorting (like in Excel 97 and 2003) Who knows how to make the warning? Thanks Anne |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2000 macro to warn before sorting
Here is a link to code I posted on May 6th... http://tinyurl.com/3dmzjn It creates application level events for the Sort toolbar buttons. You should be able to adapt it to your specific needs. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Anne Schouten" wrote in message I have a big Excel table and many users. If a user select a column and start sorting I want a message to warn the user he shouldn't select a column and stop de sorting (like in Excel 97 and 2003) Who knows how to make the warning? Thanks Anne |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2000 macro to warn before sorting
Jim, Thank you very much. This is the just the solution I was looking for.
Anne "Jim Cone" wrote in message ... Here is a link to code I posted on May 6th... http://tinyurl.com/3dmzjn It creates application level events for the Sort toolbar buttons. You should be able to adapt it to your specific needs. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Anne Schouten" wrote in message I have a big Excel table and many users. If a user select a column and start sorting I want a message to warn the user he shouldn't select a column and stop de sorting (like in Excel 97 and 2003) Who knows how to make the warning? Thanks Anne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting in excel 2000 | Excel Discussion (Misc queries) | |||
| how do i get excel to warn me that i already used a certain value | Excel Discussion (Misc queries) | |||
| error in attempt to warn about macro security | Excel Programming | |||
| 2nd try --Macro to transfer data in an Excel sheet (2000) in Access 2000 ( code to replace what wizard do) | Excel Programming | |||
| Create macro to download access 2000 table to excel 2000 spreadsheet | Excel Programming | |||
Hybrid Mode
