| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 50150 | 2004-10-11 23:55:00 | Excel: convert number to equivalent word | Tinakarori (2162) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 280398 | 2004-10-12 22:59:00 | If it returns name# it will mean you havent saved it the code in your Personal.xls file, its not located in xlstart or you havent used the correct syntax for the formula. If you prefer to create an addin then - 1) open a new workbook 2) open the VBE (ALt + F11) 3) Insert a module (Insert | Module) 4) Paste the code in the right hand window 5) Close the VBE (Alt + Q) 6) Select File|Save As and in the drop down menu 'Save As Type' select the option Microsoft Excel Addin (its right at the bottom) 7) Name the file from Book1.xla to something more descriptive for you then click OK 8) Select Tools|Addins from the menu and put a check against the name you used in step 7 then click OK. Close and re-open Excel and you should be able to use those functions. hth |
parry (27) | ||
| 280399 | 2004-10-13 01:16:00 | Still no go Parry. The ADD-IN showed up a right and was ticked but =Spellamount(a1) still produced #NAME? Dahhhhhh. Works fine attached to one particular workbook. Hmmmmmmmm? |
B.M. (505) | ||
| 280400 | 2004-10-13 02:00:00 | Thats a head scratcher then. :-) Did you change the function at all or just straight copy and paste? If the function has Private Function instead of Function (or Public Function) then this prevents viewing in other workbooks but I cant imagine you've done that. Perhaps its a security setting. Try Tools|Options, Security tab then click the macro security button and under the Trusted Sources tab you have a tick against 'Trust All Installed Add-ins and Templates'. For good measure ensure the option under the Security Level tab is Medium. |
parry (27) | ||
| 280401 | 2004-10-13 02:11:00 | Do you mean Tools-Macros-Security Parry? That is set to low and all add-inns are trusted. By the way I'm useing Excel 2000 ver 9.0.2720 not that probably makes much differance? Yea, I'm scratching my head too. |
B.M. (505) | ||
| 280402 | 2004-10-13 03:46:00 | Yes thats the same Bob, Im using xl 2002 so things may be slightly different. Im sorry but Ive run out of ideas why this wont work. As long as the codes correct it should be fine so open the addin book through Windows Explorer then open the VBE and with the module selected Debug|Compile VBA project just to make sure there is no coding errors. Note that Option Explicit should only be declared once and is the first line of code. Perhaps have a read of this and follow the example and see what happens. www.fontstuff.com |
parry (27) | ||
| 280403 | 2008-05-20 09:05:00 | just save as the workbook as addins in the save menu..hope it be useful.. | BlueSpade (6267) | ||
| 280404 | 2008-05-20 10:26:00 | After 4 years? Doubtful me thinks. Auto-lock please? |
beeswax34 (63) | ||
| 1 2 | |||||