![]() 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |