Hmm. Interesting. Well, the first point is that an add-in doesn't only have to be installed to work. It also has to be enabled in Tools-Addins, so that may be an issue. If you have no other compelling need to own a digital certificate, don't get one just for this. Instead, reduce your macro security to medium and allow users to enable the macros each time this file is opened. Incidentally, you will have to change the security level, then reopen the file before the macros become available. Ray Blake This email is from Ray Blake, Head of Software Design, GR Business Process Solutions. It is confidential and intended for the addressee only. The contents are private and may be legally privileged. If you receive this email in error we would be grateful if you would advise the sender and delete the email from your system. For more information on the services that we offer please visit us at our website: - www.grbps.com > -----Original Message----- > From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of > Roger > Sent: 20 August 2003 06:30 > To: mso@xxxxxxxxxxxxx > Subject: [mso] Subject: Re: Autonumbering in Excell > > > Thank you Ray for your quick reply. Maybe the following notes will help you > understand my problem! > > The document (a purchase order form) was created in Excel97 using a macro to > add in an autonumber. Opening the document in ExcelXP, we keep getting a > dialogue that says 'the numbering add-in must be loaded for optimum numbering > and toolbar behaviour. Please reload etc..'. We reload all the add-ins from the > original OfficeXP CD and the macro toolbar appears. HOWEVER, when we next > open the document, up comes the same dialogue again. So, How can we get > these add-ins to stay added? > > Next problem is that when we click on the Autonumber icon in the macro toolbar > another dialogue tells us Macros in this workbook are disabled because the > security level is high and the macros have not been digitally signed or verified as > safe'. It seems to make no difference setting the Security level to Low. > > Should I go through the instructions in Help for creating a digital certificate or am > I looking in the wrong area? Is it easy enough to do? > > I would appreciate any advice thanks, Roger > > Subject: [mso] Autonumbering in Excel > From: "Roger" <rogerbid@xxxxxxxxx> > Date: Mon, 18 Aug 2003 01:38:58 -0400 (EDT) > > Hi, > After upgrading from Windows98SE/Office97 to WinXP/OfficeXP an Excel > document in regular use (which had been autonumbered) is no longer giving the > option to autonumber! > The person who created the document has left the company and we are at a loss > to know how to reinstate this function. > I hope someone can assist, Thanks in advance, > Roger > > From: "Ray Blake" <ray@xxxxxxxxx> > Subject: [mso] Re: Autonumbering in Excell > Date: Mon, 18 Aug 2003 06:48:13 +0100 > > Roger, > > It's not immediately obvious what you mean by 'autonumbering'. Please > describe what the Excel file does in more detail. What aspect is it > which has some sort of automatic numbering, and at what point of running > is an number allocated, for instance? > > Ray Blake > > > > > > > _______________________________________________ > No banners. No pop-ups. No kidding. > Introducing My Way - http://www.myway.com > ************************************************************* > You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or > MicrosoftOffice@xxxxxxxxxxxxxxxx > > To send mail to the group, simply address it to mso@xxxxxxxxxxxxx > > To Unsubscribe from this group, send an email to > mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the > subject line. > > Or, visit the group's homepage and use the dropdown menu. This will also allow > you to change your email settings to digest or vacation (no mail). > //www.freelists.org/webpage/mso > > To be able to use the files section for sharing files with the group, send a request > to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with > instructions. Once you are a member of the files group, you can go here to > upload/download files: > > http://www.smartgroups.com/vault/msofiles > ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************