I've created a dialog frame in MS excel 2002 containing a set of macro assigned buttons. I'm trying to get it so that:
1) this dialog will run automatically on opening of excel preferably on top of a data rich worksheet
2) also for me to be able to assign to buttons and a keyboard shortcut a way of running the dialog frame on top of any of the other worksheets or charts in the workbook.
I've been trying to do this by creation of a macro but i'm failing to even get the dialog to run and appear outside of its design view.
Any help would be much appreciated!!
PHIL RUSH
1) this dialog will run automatically on opening of excel preferably on top of a data rich worksheet
2) also for me to be able to assign to buttons and a keyboard shortcut a way of running the dialog frame on top of any of the other worksheets or charts in the workbook.
I've been trying to do this by creation of a macro but i'm failing to even get the dialog to run and appear outside of its design view.
Any help would be much appreciated!!
PHIL RUSH