User can't see Input boxes

K

KimC

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?
 
R

Robert Flanagan

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
 
K

KimC

Robert Flanagan said:
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






.
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?
 
R

Robert Flanagan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top