Hide or unhide one or two autoshapes
 

Hi,

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

Werne

--
werne
-----------------------------------------------------------------------
werner's Profile: http://www.hightechtalks.com/m39
View this thread: http://www.hightechtalks.com/t229815

Hide or unhide one or two autoshapes
 

for example to hide

ActiveSheet.Shapes("Oval 2").Select
Selection.Visible = False

--
Greetings from New Zealand
Bill K

"werner" wrote in message
...

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

Hide or unhide one or two autoshapes
 

Very Simply... use their name...

First add to ovals to the active sheet... then
walk through this code using the debugger...

ActiveSheet.Shapes("Oval 1").Visible = False
ActiveSheet.Shapes("Oval 2").Visible = False
ActiveSheet.Shapes("Oval 1").Visible = True
ActiveSheet.Shapes("Oval 2").Visible = True


Brian

"werner" wrote in message
...

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

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

Hide or unhide one or two autoshapes
 

Thanks very much for the quick response.

Werne

--
werne
-----------------------------------------------------------------------
werner's Profile: http://www.hightechtalks.com/m39
View this thread: http://www.hightechtalks.com/t229815