Kim, most books on how to write macros give good coverage on this. Books
with just a chapter on macros are not good. Lots of web postings ranging
from very bad to marginal
Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on
VB macros for Excel
"KimC" wrote in message
...
"Robert Flanagan" wrote:
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?
.
Thanks for your help--it helps to know someone else has experienced this.
I have never used a user form. Can you point me to some help on creating
one?