Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
First off thanks to everyone here. I've come here many time with
questions and was able to find answers. And when I posted my question I've always got great help. Now I'm really stuck because it involves macros not running in a workbook I share, on someone else's pc. They get this error "Compile error: Can't find project or library. When I click debug this line gets highlighted wee1 = MsgBox("One of the worksheets you entered is incorrect. Please enter the names again" _ , vbExclamation) A coworker dimed this line then it worked. I have other msgboxes like this that i did not dim. The same goes for input boxes. and all of them are like this: Wks2 = InputBox("Enter the name of the worksheet that is to be sent to the stores") Again coworker dimed it as a string and it worked on his pc. All the while I never received an error message when running on my pc. This is not a pressing question, just a puzzling one for me. All help is greatly appreciated, and if more information is needed just let me know. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
strange happenings with move/copy worksheet | Excel Worksheet Functions | |||
weird macro | Excel Programming | |||
Wierd VBA happenings... | Excel Discussion (Misc queries) | |||
Strange Happenings | Excel Discussion (Misc queries) | |||
Macro is weird! | Excel Programming |