View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Hide or unhide one or two autoshapes

Do you know their names:

with worksheets("Sheet1")
.shapes("shape1").visible = true
.shapes("myothershape").visible = true
end with



werner wrote:

Hi,

Is it possible to hide and unhide one or two autoshapes with VBA (not
all autoshapes) and how do you do it.

Werner

--
werner
------------------------------------------------------------------------
werner's Profile: http://www.hightechtalks.com/m399
View this thread: http://www.hightechtalks.com/t2298153


--

Dave Peterson