Hi Brad, I would suggest you have your macro security set to 'high' in Excel. This will disable any loaded macros, without any prompts. Set your macro security to 'medium' (if you trust me!) This is found in Tools->Macro->Security
Regards David Watling "Brad Velander" <[EMAIL PROTECTED] To: "Protel EDA Forum" <[EMAIL PROTECTED]> .com> cc: Subject: Re: [PEDA] BOM sorter 20-Jun-2003 09:05 PM Please respond to "Protel EDA Forum" I tried it as well after seeing your message. I opened BOM Sort.XLS, saw the BOM Sort toolbar, opened a CSV BOM, clicked BOM SORT and got an error message stating "The macro "BOM sorter.xls'!BOM_sort_with_Format' cannot be found." The funny thing is that both macros appear in the list when you check the macros. Sincerely, Brad Velander. Lead PCB Designer Norsat International Inc. Microwave Products Tel (604) 292-9089 (direct line) Fax (604) 292-9010 email: [EMAIL PROTECTED] http://www.norsat.com > -----Original Message----- > From: John A. Ross [Design] [mailto:[EMAIL PROTECTED] > Sent: Friday, June 20, 2003 9:09 AM > To: Protel EDA Forum > Subject: Re: [PEDA] BOM sorter > > > Dave > > All I get out of it is run time error 13 type mismatch. > > Is the procedure just open file, load csv and go? > > Best Regards > > John A. Ross > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *