Hi

How do i add a button that if i click on sorts the worksheet? save me
doing it manually all the time

thanks
damian cutts


--
damiancutts
------------------------------------------------------------------------
damiancutts's Profile: http://www.excelforum.com/member.php...o&userid=27727
View this thread: http://www.excelforum.com/showthread...hreadid=472393

Hi Damian,

How do i add a button that if i click on sorts the worksheet? save me
doing it manually all the time

Why not use the standard toolbar sort button.

If this is not appropriate to your needs, perhaps you should provide
additional explanation.

---
Regards,
Norman



"damiancutts"
wrote in message
...

Hi

How do i add a button that if i click on sorts the worksheet? save me
doing it manually all the time

thanks
damian cutts


--
damiancutts
------------------------------------------------------------------------
damiancutts's Profile:
http://www.excelforum.com/member.php...o&userid=27727
View this thread: http://www.excelforum.com/showthread...hreadid=472393

i wish to add a button under each column so when published on web
columns can also be sorted. i have managed to add them off-line by
recording a macro and assigning it to a button. but when i save the
excel file as a html file, and publish it on the web the buttons no
longer work


--
damiancutts
------------------------------------------------------------------------
damiancutts's Profile: http://www.excelforum.com/member.php...o&userid=27727
View this thread: http://www.excelforum.com/showthread...hreadid=472393

Hi Damian,
Unless Microsoft changes their EULA there are so many restrictions
on what you can do with Excel published to a website as interactive code.

In any case macros will not work.

You can sort an HTML table with a bookmarklet -- the sort is strictly a
TEXT sort.

Bookmarklets (JavaScript Favelets)
http://www.mvps.org/dmcritchie/ie/bookmarklets.htm

The sort table bookmarklet is from Jesse Ruderman's squarefree.com
http://www.squarefree.com/bookmarklets/pagedata.html

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"damiancutts" wrote in message
...

i wish to add a button under each column so when published on web
columns can also be sorted. i have managed to add them off-line by
recording a macro and assigning it to a button. but when i save the
excel file as a html file, and publish it on the web the buttons no
longer work


--
damiancutts
------------------------------------------------------------------------
damiancutts's Profile: http://www.excelforum.com/member.php...o&userid=27727
View this thread: http://www.excelforum.com/showthread...hreadid=472393