Simple automatic sort of range

[opopanax666]

Hi guys & gals,

I've got a range (let's say B2:H17) that I want to automatically sort on column C. Easy enough with a macro, but I can't seem to explain to some co-workers how to use the macro... so, to make it easier for everyone, I'd like it to be automated.

Thanx in advance for the feedback.

[Bryan Hessey]

Why not add a Button, named "Sort Range"

In View, Toolbars, tick Control Toolbox

The first icon toggles design Mode

In Design mode, select a button and then draw the shape of where you want it to be (it's fully moveable)

Move the code from your macro to the Button's code area, Exit design mode and test.

You can re-enter Design mode to adjust colour and location etc of the Button.

-------

You could also do the sort as a Menu item, but a button is easier for the rest of te staff to see. (ie, a reminder)

hth
---

Hi guys & gals,

I've got a range (let's say B2:H17) that I want to automatically sort on column C. Easy enough with a macro, but I can't seem to explain to some co-workers how to use the macro... so, to make it easier for everyone, I'd like it to be automated.

Thanx in advance for the feedback.

[opopanax666]

Thank you, works a treat