View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tsunami3169 Tsunami3169 is offline
external usenet poster
 
Posts: 11
Default Weird Macro Happenings

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