+ Reply to Thread
Results 1 to 6 of 6

Hide / Unhide pictures with VBA

  1. #1
    Registered User
    Join Date
    04-06-2020
    Location
    Brussels, Belgium
    MS-Off Ver
    Windows 10
    Posts
    7

    Hide / Unhide pictures with VBA

    Dear Forum,

    I am a new member with a problem. Hope one of you can help me out....
    I have the following code in VBA to hide some objects on my screen


    #

    The strange thing is it works flawless in debugging mode (F8) but it fails to work when called as a procedure.

    Does anyone know what I am doing wrong ?

    Thanks in advance for your feedback.

    Kind regards from Belgium.
    Tom.
    Last edited by johnlebeau; 04-07-2020 at 10:20 AM. Reason: code was not entered the right way

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Hide / Unhide pictures with VBA

    Hi & welcome to the board.

    Please edit your post to enclose the code in code tags, the # icon in the reply/edit window. As per board rules.

    As for the code replace Activesheet with sh

  3. #3
    Registered User
    Join Date
    04-06-2020
    Location
    Brussels, Belgium
    MS-Off Ver
    Windows 10
    Posts
    7

    Re: Hide / Unhide pictures with VBA

    Problem solved.
    Thanks a million.

    I am sorry but I do not understand your remark.
    .... am not an IT person ;-)

    Kind regards
    Tom.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Hide / Unhide pictures with VBA

    You need to edit you original post, select the code you posted & then click the # icon in the edit window.

  5. #5
    Registered User
    Join Date
    04-06-2020
    Location
    Brussels, Belgium
    MS-Off Ver
    Windows 10
    Posts
    7

    Re: Hide / Unhide pictures with VBA

    Not sure I did it the right way ..... :-/
    Tom

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Hide / Unhide pictures with VBA

    No, you managed to delete the code, but never mind.
    I'm glad your problem is solved & thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] hide/show pictures
    By jc83ph in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-11-2019, 02:00 PM
  2. Show and hide the pictures based on the value.
    By jc83ph in forum Excel General
    Replies: 22
    Last Post: 05-27-2018, 02:04 AM
  3. [SOLVED] Hyperlink with pictures and hide Sheets
    By murray83 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-03-2017, 08:35 AM
  4. [SOLVED] Which below code, I can Hide & unhide, but I want only allow to HIDE
    By rajeshn_in in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-14-2016, 04:10 AM
  5. Hide Visibility hide and unhide menu using macro ?
    By jasond1992 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-30-2015, 09:05 PM
  6. [SOLVED] Checkbox the shows/hide two pictures
    By mlcfexcel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-27-2015, 01:50 PM
  7. Show/Hide Button for Pictures
    By aposatsk in forum Excel General
    Replies: 2
    Last Post: 08-23-2006, 10:30 AM

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