If you put your code in add-ins and then set the add-ins to auto-load (File, Options, Add-ins, GO button beside "Manage Excel Add-in", then the user doesn't need to worry about enabling macros. And, by separating your code from your data workbooks, you can update the code without worrying about the data. And with macros workbooks, you can easily add custom tabs to the ribbon for ease of access.

Robert Flanagan
Add-ins.com LLC
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, fax 302-234-9859
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel