Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
EA EA is offline
external usenet poster
 
Posts: 12
Default Error using a combo box with an assigned macro in Excel

I have a combo box in an Excel worksheet with an assigned macro so that
whenever a selection is changed within the combo box, that assigned macro
will execute. I've noticed that the macro will execute its function, but
then a prompt appears with a yellow exclamation sign stating exactly this:

€˜ €˜My File.xls€ could not be found. Check the spelling of the file name, and
verify that the file location is correct.

If you are trying to open the file from your list of most recently used
files on the File menu, make sure that the file has not been renamed, moved,
or deleted.

Then with an 'OK' button to close this prompt. I've ran the macro via
Alt+F8 and the macro executes as it should. I have other tabs and files with
the same combo box and macro feature with no problems, but can't seem to
identify the glitch.

Any ideas...SOS!!!!
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
Macro assigned to Toolbar problem JHL Excel Discussion (Misc queries) 2 March 22nd 07 11:44 PM
Macro assigned to a button Sadcrab Excel Discussion (Misc queries) 12 December 8th 06 11:16 PM
Macro Assigned to a Button zephyr Excel Discussion (Misc queries) 1 October 25th 06 03:33 PM
How do I know what macro is assigned to a button? Denise in NC Excel Discussion (Misc queries) 3 April 3rd 06 02:31 PM
How to delete a macro that has been assigned to run when workshee. tcsigecan Excel Worksheet Functions 1 December 28th 04 10:11 PM


All times are GMT +1. The time now is 08:12 AM.

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"