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?