Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide/Unhide row VBA | Excel Discussion (Misc queries) | |||
Hide/Unhide | Excel Discussion (Misc queries) | |||
Hide Unhide | Excel Discussion (Misc queries) | |||
Hide/unhide | Excel Worksheet Functions | |||
Hide AutoShapes On Excel Worksheet | Excel Worksheet Functions |