Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc
Thinkpad21
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
renegan
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc
Puppet_Sock
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
make it possible to get to the function reference for excel when an unhappy excel user Excel Discussion (Misc queries) 1 April 21st 06 12:12 AM
Improve Excel Help Text - Make easier to Find Function Refs RichardAllen Excel Worksheet Functions 0 April 10th 06 05:52 AM
How do I put a button on an excel spreadsheet to print a report? Casper Excel Discussion (Misc queries) 2 July 28th 05 03:21 AM
Excel 2K3: Opening spreadsheet, also opens book1.xls? Newtek Setting up and Configuration of Excel 1 July 6th 05 07:56 PM
Statistical Excel Function Question within Excel 2000... Drew H Excel Worksheet Functions 3 October 31st 04 07:55 PM


All times are GMT +1. The time now is 03:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"