+ Reply to Thread
Results 1 to 5 of 5

Unable to Hide/Unhide Shapes and Buttons with VBA: Error 400

  1. #1
    Registered User
    Join Date
    11-19-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    13

    Unable to Hide/Unhide Shapes and Buttons with VBA: Error 400

    I have a workbook where I'm trying to hide certain CommandButtons and Shapes when the user clicks on a button. My VBA code to accomplish this logic is:

    Please Login or Register  to view this content.
    Problems:
    1. Message Box stating '400' comes up when code is executed
    2. CommandButtons are not hidden
    3. Shape "GroupBox35" is not hidden

    Please help. I've also had no luck finding out what '400' means in this context. Excel is also not being descriptive about this '400'.
    Last edited by mp4-4; 10-21-2013 at 12:35 PM.

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Unable to Hide/Unhide Shapes and Buttons with VBA: Error 400

    can you attach a sample file ?
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    11-19-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Unable to Hide/Unhide Shapes and Buttons with VBA: Error 400

    Hide Shapes, Buttons error.xls

    Please see attached file.

  4. #4
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Unable to Hide/Unhide Shapes and Buttons with VBA: Error 400

    Please Login or Register  to view this content.
    Last edited by patel45; 10-21-2013 at 03:09 PM.

  5. #5
    Registered User
    Join Date
    11-19-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Unable to Hide/Unhide Shapes and Buttons with VBA: Error 400

    Quote Originally Posted by patel45 View Post
    Please Login or Register  to view this content.
    Same thing, no change in behavior.

+ 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. How to Hide/Unhide Command Buttons along with Columns
    By EddieN1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2013, 09:53 AM
  2. [SOLVED] Buttons need to hide/unhide along with columns
    By rowlandjp in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-28-2012, 03:29 PM
  3. Can I Hide Shapes That Are Buttons???
    By JonesZoid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-08-2012, 05:32 PM
  4. Displaced control buttons after hide unhide
    By reinkonemann in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-11-2011, 10:36 AM
  5. I am missing something (hide / unhide rows with buttons)
    By Turquoise_dax in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2006, 01:01 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