Pop Up icons
 

Hi,

I've designed a macro that allows the user to select icons
controlling macros to pop up on demand from a menu.
I also write the details of which icons are open to the
registry so that when Excel opens they are again displayed.

However they have a tendancy to pop up all over the place
rather than attach themselves neatly to the end of an
existing tool bar.

The user then has to drag them back to the top so that the
s/sheet can be displayed full screen.

Any suggestions as to how to control this...??

Rgds

Chris

Pop Up icons
 

By icons, I'm thinking you mean CommandBar.
You've got a docking problem.

In the Excel Help:

Position Property Example

This example steps through the collection of command bars, docking the
custom command bars at the bottom of the application window and docking the
built-in command bars at the top of the window.

For Each bar In CommandBars
If bar.Visible = True Then
If bar.BuiltIn Then
bar.Position = msoBarTop
Else
bar.Position = msoBarBottom
End If
End If
Next




"Chris Gorham" wrote in message
...
Hi,

I've designed a macro that allows the user to select icons
controlling macros to pop up on demand from a menu.
I also write the details of which icons are open to the
registry so that when Excel opens they are again displayed.

However they have a tendancy to pop up all over the place
rather than attach themselves neatly to the end of an
existing tool bar.

The user then has to drag them back to the top so that the
s/sheet can be displayed full screen.

Any suggestions as to how to control this...??

Rgds

Chris