C
Celtic_Avenger
Hi
Can Someone Help?
I have a sreadsheet that runs a dialog box as a menu for navigation.
Within the disalog box are about 30 buttons each either taking the user
to another sheet or running another macro.
In all of the macros linked to each button in the menu I have placed
the following as the first command:
ThisWorkbook.DialogSheets("MenuDialog").Hide
I have ensured that the "name" is correct.
The macros will sometimes bring up a further dialog or msgbox, but the
original MenuDialog box does not dissapear as requested before the
second box or action takes place. This can make the running of the
macros look very untidy. Where if each box dissapeared before the next
one oppened, thats much neater and easier to follow by the user, It
would also eliminate the possibility of the user pressing a button
twice and running a macro linked to the first box instead of the new
requested operation by the second box.
I previously posted this same problem and was dvised to use the
command
Application.ScreenUpdating = True (and False)
I placed the true argument after the Dialog hide command, this did
nothing, it still waited until all macros running had completely
finnished before removing the boxes.
Any other ideas, would pausing the macros help, is this possible, or
could a combination of the commands along with the RefreshAll commands
to ensure activity down to sheet level. I dont know, if any of these
stab ideas would be the one to look down, or if I would be waisting my
time.
Any help with this would be great.
Its nice to make programs look as pleasing to run as they are to use!
Thanks.
Celtic_Avenger
Can Someone Help?
I have a sreadsheet that runs a dialog box as a menu for navigation.
Within the disalog box are about 30 buttons each either taking the user
to another sheet or running another macro.
In all of the macros linked to each button in the menu I have placed
the following as the first command:
ThisWorkbook.DialogSheets("MenuDialog").Hide
I have ensured that the "name" is correct.
The macros will sometimes bring up a further dialog or msgbox, but the
original MenuDialog box does not dissapear as requested before the
second box or action takes place. This can make the running of the
macros look very untidy. Where if each box dissapeared before the next
one oppened, thats much neater and easier to follow by the user, It
would also eliminate the possibility of the user pressing a button
twice and running a macro linked to the first box instead of the new
requested operation by the second box.
I previously posted this same problem and was dvised to use the
command
Application.ScreenUpdating = True (and False)
I placed the true argument after the Dialog hide command, this did
nothing, it still waited until all macros running had completely
finnished before removing the boxes.
Any other ideas, would pausing the macros help, is this possible, or
could a combination of the commands along with the RefreshAll commands
to ensure activity down to sheet level. I dont know, if any of these
stab ideas would be the one to look down, or if I would be waisting my
time.
Any help with this would be great.
Its nice to make programs look as pleasing to run as they are to use!
Thanks.
Celtic_Avenger