Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User can't see Input boxes
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User can't see Input boxes
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User can't see Input boxes
"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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
User can't see Input boxes
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prompt user for input and utilize that input | Excel Worksheet Functions | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Mask input in input boxes? | Excel Programming |