View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default The Placement property does not seem to be working.

I wasn't sure of your exact scenario but originally intended to suggest
same as Claus did, and also suggest putting your controls as menuitems
so they're not on the sheet at all. Menuitems can be a custom menu or
toolbar, or in XL2007 and later, a custom tab on the ribbon. These
would be created when your file opens, and removed when it closes. My
preference for my projects is that they have there own menus, but I
also put controls above a Freeze Panes row when menus aren't
appropriate or warranted!

Note that the base for control coords is the worksheet, not the screen
as would be for a userform. IOW, when you create controls on worksheets
they become 'children' of their host sheet. The Placement options do
not apply to screen position, but rather aplly to sheet coord position.

Claus' value 15 is what works for his display and so you'd have to find
what works for yours. Problem is it may not work for other users of
your project and so is why I recommend going with custom menus!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion