Tom,

Your comment is special to me - Thank you!

--
steveB

Remove "AYN" from email to respond
"Tom Ogilvy" wrote in message
...
Just to add to Steve's contribution:

http://www.microsoft.com/officedev/index/apps.htm
Distributing Microsoft Excel 97, Word 97, and PowerPoint 97 Solutions
(March
3, 1997)

http://www.microsoft.com/exceldev/tips/addins.htm
Protecting the Code in an Add-in


http://msdn.microsoft.com/library/en.../xlcraddns.asp
Creating Add-ins in Microsoft Excel 97

http://support.microsoft.com/?id=167909
XL: Securing Visual Basic Code in Microsoft Excel

http://support.microsoft.com/?id=156942
XL97: How to Create an Add-in File in Microsoft Excel 97

While some where written around the Office 97 timeframe, they are still
applicable for regular addins.

--
Regards,
Tom Ogilvy


"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