Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Icon from arrow to Sand hour
Sub Auto_Open()
Dim Res As Long Res = MsgBox("TEST", _ Buttons:=vbYesNo + vbQuestion, _ Title:="") If Res = vbYes Then Call Inputdate End Sub Before I click Yes/No - my icon changes from arrow to sand hour - how can i prevent this?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Icon from arrow to Sand hour
Hi,
The code below works fine and doesn't look like the cause of your problem. Perhaps there is more code executing in the workbook_open event module. have a look there. Mike "transferxxx" wrote: Sub Auto_Open() Dim Res As Long Res = MsgBox("TEST", _ Buttons:=vbYesNo + vbQuestion, _ Title:="") If Res = vbYes Then Call Inputdate End Sub Before I click Yes/No - my icon changes from arrow to sand hour - how can i prevent this?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting and arrow icon sets | Excel Discussion (Misc queries) | |||
Conditional Formatting Arrow Icon Set | Excel Discussion (Misc queries) | |||
Excel 2007 desktop icon changes to gray arrow | Excel Discussion (Misc queries) | |||
How do I follow an arrow to a worksheet icon when tacing dependent | Excel Worksheet Functions | |||
convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions |