+ Reply to Thread
Results 1 to 4 of 4

Unhide worksheets with message box entry

  1. #1
    Registered User
    Join Date
    04-03-2010
    Location
    Orlando, FL
    MS-Off Ver
    Office 365
    Posts
    94

    Unhide worksheets with message box entry

    I have some code, the purpose of which is to unhide a group of worksheets based on the data entry of one or two cells (H11 and H12). I am trying to enforce this by way of a message box entry. The problem I am encountering is that the only place I can find that it works (more or less) is in the Worksheet_Change event, and the problem with this is that every other line of code that causes a change in the worksheet will invoke the message box. I only want it to appear based on a change in range H11. If i try to to put it in the Worksheet_SelectionChange then it crashes (hard - stack overflows and other errors, including simply shutting down). I'd appreciate any advice here, or maybe there's another way to do it... The terms UnhideOpen, UnhideTSC, UnhideRoutine and UnhideDemo refer to the various worksheet groups.
    Please Login or Register  to view this content.
    Last edited by wpryan; 04-27-2010 at 05:37 PM. Reason: Solved

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Unhide worksheets with message box entry

    Try thiis,

    Please Login or Register  to view this content.

    Cheers

    Sorry for rush on time limited machine
    Last edited by Marcol; 04-27-2010 at 11:09 AM. Reason: Errors in code corrected

  3. #3
    Registered User
    Join Date
    04-03-2010
    Location
    Orlando, FL
    MS-Off Ver
    Office 365
    Posts
    94

    Re: Unhide worksheets with message box entry

    Thanks for your help. I had to change the line
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    in order to get rid of a "Sub or Finction not defined error. However, when I did that and ran the code, It looks like it's going through a huge loop until an error message appears:

    Run-time error -2147417848 (80010108)
    Method '_Default' of object 'Range' failed

    Then Excel shuts down...
    Last edited by wpryan; 04-26-2010 at 12:11 PM. Reason: Incomplete answer

  4. #4
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Unhide worksheets with message box entry

    Hi

    I have corrected my mistake in post #2 and redefined answer (now Response as Long).
    Sorry about that. (I have edited post #2 rather than post the revised code.)

    I have tried the code and can find no problems.

    Obviously I cannot test your subs UnhideOpen, UnhideTSC, UnhideRoutine, and UnhideDemo.

    I think it is in one of these that the problem must lie,

    Can you post these subs, or better still a sample version of your workbook?

    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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