Excel 2000 macro to warn before sorting

[Anne Schouten]

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

 

[Jim Cone]

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" <[email protected]>
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

 

[Anne Schouten]

Jim, Thank you very much. This is the just the solution I was looking for.

Anne