Floating form/window?

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/ **
 
J

jimbo693

dont know if this will do it for you but what about setting up a custo
toolbar with the buttons you need on that, once you set it up it wil
be on every workshee
 
J

jimbo693

go to view/toolbars/customise. select new. name your toolbar. the
select autoshapes. select the rectangle drag in to your new toolba
rightclick on it and set parameters as you want them, repeat as yo
need t
 
D

Dimetric Houston

Thanks for that.

How do connect VBA code to the new buttons I put in the new toolbar? If
I right-click on the buttons, it just opens a menu allowing for more
toolbars.

Left-clicking on the buttons just presses them. I can't get the VBA
editor to open a procedure window to let me input code for the buttons.
(the toolbar doesn't appear anywhere in the project window of VBA).

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete rows in worksheet 4
Date Formatting 3
Floating Excel window 3
Can Fkeys be used similiar to _beforedoubleclick( 1
How to use multiple command button to copy user form data to multiple worksheet 0
macro to copy a worksheet 2
auto-hyperlinking worksheet but also showing a cell value beside it 1
deleting random amounts of data from user selected columns.. 1

Top