+ Reply to Thread
Results 1 to 7 of 7

Unable to hide different pages using the multi-page element

  1. #1
    Registered User
    Join Date
    12-02-2014
    Location
    Circleville, Ohio
    MS-Off Ver
    Office 360
    Posts
    10

    Unable to hide different pages using the multi-page element

    When using the multi-page element, not mater what kind of format that I use, an error message is usually following. As shown by the below tag I am trying to hide the different pages in the module. The different pages were renamed "pgTapeMovement", "pgShipManifest", and "pgDamageTape". The error code that is received is: "Run-Time Error 5 (Invalid procedure call or argument. frmMediaMovement is the actual name of the form.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,963

    Re: Unable to hide different pages using the multi-page element

    You need to post the code.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    12-02-2014
    Location
    Circleville, Ohio
    MS-Off Ver
    Office 360
    Posts
    10

    Re: Unable to hide different pages using the multi-page element

    The following is the code I use in the module


    MultiPage1.Pages("pgDamagedTape").Visible = False

  4. #4
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Unable to hide different pages using the multi-page element

    I note that in the OP the page is named pgDamageTape and the code in #3 is pgDamagedTape
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  5. #5
    Registered User
    Join Date
    12-02-2014
    Location
    Circleville, Ohio
    MS-Off Ver
    Office 360
    Posts
    10

    Re: Unable to hide different pages using the multi-page element

    Sorry about the typo, it is "pgDamageTape"

  6. #6
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Unable to hide different pages using the multi-page element

    It worked for me.

    Are you sure that you renamed the individual Pages and not the MultiPage control?
    Are you trying to hide the last visible page?
    Does the code work if you substitute index numbers (0-based) for the names?

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    12-02-2014
    Location
    Circleville, Ohio
    MS-Off Ver
    Office 360
    Posts
    10

    Re: Unable to hide different pages using the multi-page element

    Thank you for putting me on the right track

+ 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. Print all pages in a Multi page userform
    By Alro in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-24-2020, 03:54 PM
  2. Replies: 0
    Last Post: 07-30-2014, 11:25 AM
  3. Get total pages per sheet and set page numbers in page footer by formula
    By Snoopy2003 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2013, 04:00 PM
  4. [SOLVED] sheet tabs as page number and in a cell page of pages?
    By mfgsol@gmail.com in forum Excel General
    Replies: 0
    Last Post: 11-22-2005, 10:50 AM
  5. [SOLVED] I want to print multi pages on one page.
    By Laurie in forum Excel General
    Replies: 2
    Last Post: 08-24-2005, 07:05 AM

Tags for this Thread

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