D
Dimetric Houston
Hello all.
Is there a way to have a "floating" form on an Excel spreadsheet? What
I mean is to have a form (with controls) that always is available no
matter what worksheet the user clicks on.
For my particular project, there will be about 50 worksheets in this one
project. What I want is to have a form (or window) that is always
available so that the user can add a new member whenever they wish.
I thought about using a command button, but then I don't know how to
make that button appear on each worksheet.
The new member would always be added to the active worksheet (or the
current worksheet to date), so if I had a way to always make a button
appear on the current-to-date worksheet, that would work.
Can anyone help me here?
Thanks.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **
Is there a way to have a "floating" form on an Excel spreadsheet? What
I mean is to have a form (with controls) that always is available no
matter what worksheet the user clicks on.
For my particular project, there will be about 50 worksheets in this one
project. What I want is to have a form (or window) that is always
available so that the user can add a new member whenever they wish.
I thought about using a command button, but then I don't know how to
make that button appear on each worksheet.
The new member would always be added to the active worksheet (or the
current worksheet to date), so if I had a way to always make a button
appear on the current-to-date worksheet, that would work.
Can anyone help me here?
Thanks.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **