stevespauldi
12-20-2009, 07:11 AM
I have a workbook with multiple worksheets and multiple vba modules.
When I first open the workbook, I want to use the validation input message for the opening active cell as a user instruction (i.e. exactly what to do first).
The problem is that when I first open the workbook the validation input message is visible for a second or two, but then disappears. If I then manually ‘reselect’ that cell, the validation input message does reappear.
How can I keep the validation input message visible on the screen when I first open the workbook??
I am using subroutine Events (e.g. Workbook_Open, Worksheet_Activate, Worksheet_Change, Worksheet_SelectionChange); I am using commands (i.e. Application.DisplayAlerts = Yes/No, Application.Enable Events = True/False); and I am using Protection with a password. I can send code if necessary.
Thanks very much for any help or suggestions.
Steve
When I first open the workbook, I want to use the validation input message for the opening active cell as a user instruction (i.e. exactly what to do first).
The problem is that when I first open the workbook the validation input message is visible for a second or two, but then disappears. If I then manually ‘reselect’ that cell, the validation input message does reappear.
How can I keep the validation input message visible on the screen when I first open the workbook??
I am using subroutine Events (e.g. Workbook_Open, Worksheet_Activate, Worksheet_Change, Worksheet_SelectionChange); I am using commands (i.e. Application.DisplayAlerts = Yes/No, Application.Enable Events = True/False); and I am using Protection with a password. I can send code if necessary.
Thanks very much for any help or suggestions.
Steve