View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
mcm mcm is offline
external usenet poster
 
Posts: 1
Default Floating control box

JON-JON wrote:
*Hi,

If I understand it correctly your control button is an embedded
object to
the 'main' sheet. If you hide the 'main' sheet the button will no
longer
visible. So what you want is button that will always be visible even
if the
'main' sheet is hidden. Custom toolbars will work fine for this but
you
have to attached this toolbars to your workbook to make it available
to
other users.

If this doesn't suit your needs maybe the best way is for you to
create a
userform. I can not explain it detailed to you but I wish that could
give
you an idea where to start.

Pardon me if I just wasted your time I am just trying to help to the
best I
can.

Goodluck!

Jon-jon
.
* [/color]

Jon-jon, don't sweat it mate. Everything's cool. I appreciate your
suggestion. Who knows maybe you can help me with another vb problem in
the future.

cheers