Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Connect a number to a picture bank and import that picture to exce Dennis Hedo Excel Discussion (Misc queries) 1 March 22nd 10 02:17 PM
unhide row does not unhide the hidden rows nikita Excel Worksheet Functions 4 May 24th 08 02:59 PM
insert a picture in to a comment but picture not save on hard disk Pablo Excel Discussion (Misc queries) 0 February 21st 07 03:48 PM
False and msoFalse Fox via OfficeKB.com Excel Programming 2 May 3rd 06 09:39 PM
how do i unhide a worksheet in excel 2003? unhide tab don't work mikekeat Excel Discussion (Misc queries) 2 March 6th 06 03:36 AM


All times are GMT +1. The time now is 03:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"