Results 1 to 2 of 2

Invisible and/or Visible Picture

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-02-2010
    Location
    singapore
    MS-Off Ver
    MS365
    Posts
    287

    Invisible and/or Visible Picture

    Dear All,

    I have below code done by my ex colleague.
    I trying to edit the code but failed

    This macro allow me to visible & invisible the signature of inv sheet & pl sheet.
    Now i would like to extent it to sheet BC, Sheet ADV & Sheet CO.

    Can the expert here let me know how should i do about it?


    Private Sub Workbook_Open()
    
        ActiveSheet.Shapes("Picture 17").Select
        Selection.ShapeRange.PictureFormat.Brightness = 0.5
        Selection.ShapeRange.PictureFormat.Contrast = 0.5
        Selection.ShapeRange.PictureFormat.CropLeft = 0#
        Selection.ShapeRange.PictureFormat.CropRight = 0#
        Selection.ShapeRange.PictureFormat.CropTop = 0#
        Selection.ShapeRange.PictureFormat.CropBottom = 0#
        ActiveSheet.Shapes("Picture 17").Visible = False
        Sheets("PL").Select
        ActiveSheet.Shapes("Picture 5").Select
        Selection.ShapeRange.PictureFormat.Brightness = 0.5
        Selection.ShapeRange.PictureFormat.Contrast = 0.5
        Selection.ShapeRange.PictureFormat.CropLeft = 0#
        Selection.ShapeRange.PictureFormat.CropRight = 0#
        Selection.ShapeRange.PictureFormat.CropTop = 0#
        Selection.ShapeRange.PictureFormat.CropBottom = 0#
        ActiveSheet.Shapes("Picture 5").Visible = False
        Sheets("INV").Select
        Range("H3").Select
        
    End Sub
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to make invisible application visible again?
    By GIS2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-29-2013, 07:10 PM
  2. Buttons visible/Invisible
    By LisaPatch in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2011, 11:36 AM
  3. Visible/Invisible Several Button, 3 Criteria
    By blues_oo7 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-02-2011, 09:22 AM
  4. Row Visible / Invisible
    By RoyMakaay1985 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2009, 06:00 AM
  5. invisible text boxes becoming visible
    By Jordan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2005, 08:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1