Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc
|
|||
|
|||
Excel function button in spreadsheet
Sorry, not very efficient in Excel, but have the following problem :
When clicking on a function button on an existing excel sheet, it tells me "file could not be found, check the spelling of the file name, and verify that the file location is correct... The file name it gives me is an older version of the same file with a different name, how can I change this or remove this error... Thanks !!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel function button in spreadsheet
It sounds like someone else wrote the code for that function button, so I recommend you to contact that person to make the change. If there is no way to contact the person, you can try to open the VBA Editor and try to find the code controls that button, where you can make that change. Again if you don't know VBA I don't recommend that. You can open VBA Editor with Alt+F11 shortcut. -- renegan ------------------------------------------------------------------------ renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450 View this thread: http://www.excelforum.com/showthread...hreadid=536072 |
#3
Posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc
|
|||
|
|||
Excel function button in spreadsheet
Thinkpad21 wrote:
Sorry, not very efficient in Excel, but have the following problem : When clicking on a function button on an existing excel sheet, it tells me "file could not be found, check the spelling of the file name, and verify that the file location is correct... The file name it gives me is an older version of the same file with a different name, how can I change this or remove this error... Is it a Form button? If so, you should be able to right click on the button, then choose Assign Macro and change what gets run when you click. Socks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make it possible to get to the function reference for excel when | Excel Discussion (Misc queries) | |||
Improve Excel Help Text - Make easier to Find Function Refs | Excel Worksheet Functions | |||
How do I put a button on an excel spreadsheet to print a report? | Excel Discussion (Misc queries) | |||
Excel 2K3: Opening spreadsheet, also opens book1.xls? | Setting up and Configuration of Excel | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |