Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro assigned to Toolbar problem | Excel Discussion (Misc queries) | |||
Macro assigned to a button | Excel Discussion (Misc queries) | |||
Macro Assigned to a Button | Excel Discussion (Misc queries) | |||
How do I know what macro is assigned to a button? | Excel Discussion (Misc queries) | |||
How to delete a macro that has been assigned to run when workshee. | Excel Worksheet Functions |