Thread: Hide or unhide one or two autoshapes
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Brian Brian is offline
external usenet poster
  
Posts: 25
Default 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



Reply With QuoteReply With Quote