Kim, are you using Application.Inputbox? If so, switch to a userform. I
have seen problems in where the inputbox never appears and acts like it was
canceled, stopping the macro. I blame it on worksheet corruption.
Obviously it is not corrupt when you sent to him. But perhaps something is
wrong with his installation of excel causing the same result. You could
also ask him to repair Excel per the instructions at
http://www.add-ins.com/how_to_repair_office.htm

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel



"KimC" wrote in message
...
I have an Excel spreadsheet with buttons that run macros. I am using Excel
2007 and have 2 monitors. I created the sheet with the Excel application
window on my "extended desktop" monitor and the Visual Basic window on my
"primary" monitor. Now, when I e-mail the workbook to another user who
only
has his laptop monitor, nothing happens when he clicks the buttons to run
the
macros. Clicking a button should cause an Input box to appear where the
user
is asked to click in a cell of a particular color, but he sees nothing.
Pressing ESC should fire a message box that the operation has been
cancelled. He sees nothing. He has enabled the macros upon opening the
workbook and I saved and sent the file as a "macro-enabled" file.
I suspected that my dual monitor setup was the culprit, so I disconnected
my
extended desktop monitor, re-booted, opened the file, confirmed that the
buttons work as they should, saved the file and e-mailed it again. The
user
reported that he still can't run the macros.
I'm stuck-can anyone help?