Write the code in a workbook.xls
than save it as workbook.xla

This is an add-in

--
steveB

Remove "AYN" from email to respond
"dherne" wrote in
message ...

Thanks, but can you please give me more inforamtion. Is it possible to
have some sort of 'global' macro that will work, even if they create a
new spreadsheet from scratch? If so, how?

For example, if I choose Ctrl-Alt-S to do my custom sorting macro, is
there a way to make it work for all future spreadsheets that are
created?

How can I automatically install this macro for the user?

Thanks,
Deise


--
dherne
------------------------------------------------------------------------
dherne's Profile:
http://www.excelforum.com/member.php...o&userid=25067
View this thread: http://www.excelforum.com/showthread...hreadid=385859