so the module as written, when trying to use formatmac(a1) it says syntax error, but formatmac(1122334455) produces 11:22:33:44:55 Ok, got it to work, i added it again as a module as this time it saw it. so it looks like Excel at least found it, but in the worksheet it will not let me use it. Avec? when powering on the computer today and opening up that file, it had a warning message that a macro is there from a source that cannotīe verified, enable macros anyway? yes. If i try to enter a function =FormatMAC(a1) then hit enter, it, the cell, says "Name?" as if it cannot find it at all. so i copied/pasted the function, and saved it, but in the spreadsheet But in Excel 2007 there is NOTHING in any of the menus there that indicates this, i had to find out from reading articles.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |