Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unhide Picture Using msoFalse
I suppose it cannot find the picture and fails on the ActiveSheet
instruction. No need to select - Sub test() s$ = "Rectangle 1" HideUnhide s, False Stop HideUnhide s, True End Sub Sub HideUnhide(sName As String, bVisible As Boolean) ActiveSheet.Shapes(sName).Visible = bVisible End Sub Regards, Peter T "Marvin" wrote in message ... I am using Excel 2003 and executed the following macro command; ActiveSheet.Shapes("P25%").Select Selection.ShapeRange.Visible = msoFalse I cannot reverse the process and receive and error if I use msoTrue. I suppose it cannot find the picture and fails on the ActiveSheet instruction. I cannot find any menu item to unhide this picture. HELP! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Connect a number to a picture bank and import that picture to exce | Excel Discussion (Misc queries) | |||
unhide row does not unhide the hidden rows | Excel Worksheet Functions | |||
insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) | |||
False and msoFalse | Excel Programming | |||
how do i unhide a worksheet in excel 2003? unhide tab don't work | Excel Discussion (Misc queries) |