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

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

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