Where are my Controls of my Excell ??

[JackONeill]

Hi all,

2007 has arrived with his problems... lol...

Here mine...

I'm working with Excell (Windows xp pro).

I have made a Excell sheet with VBA code and a lot of Controls on the sheet... These control have deseapeer..

All of them... inside all the excell sheet....

But the VBA code is still working... (I detect a case change..)

But all the spiner... Option... are gone (with the wind?)..

Do you have an idea ????

BTW: We have re install Excell ... and there is still the Problem.. and the file is ok on other computer !!....


I'm lost... on a Island... and Nobody... Nobody at the horizont !!


Cya later !

 

[SkipVought]

Hi,

In the code window the the sheet in question paste and run...

sub WhatControls()
  dim shp as shape
  for each shp in activesheet.shapes
    with shp
      msgbox .name & ":@" & .top & " down " & .left & " in & " & .width & "x" & .height
    end with
  next
end sub

I have a feeling that they are there. Let me know.
will give you an indication of the shapes on the sheet.

Skip,

_[red][/red]

 

[JackONeill]

Thanks for the tips..

but i manage to fix the problem...

Don't know really where it come from...


Could it be from a VB program badly programed???

As i can understand from your code you can make appears the controls??

So is it possible to make them disappears????

 

[SkipVought]

Under some conditions, the size and position can change, maybe to the point that the control APPEARS to have disappeared.

Right-click the control anc check the Properties. You may want to change the MOVE & SIZE options.

Skip,

_[red][/red]