+ Reply to Thread
Results 1 to 6 of 6

Listbox is deactivated, no known cause

  1. #1
    Forum Contributor
    Join Date
    08-14-2006
    Location
    USA
    MS-Off Ver
    2019
    Posts
    686

    Listbox is deactivated, no known cause

    ActiveX Listbox XL 2010

    2 columns
    ListStyle: 1- fmListStyleOption
    MultiSelect: 1 - fmMultiSelectMulti
    ListFillRange is a 2 column Excel Table

    Resides in a template. This template is in lieu of a giant userform. It allows the user to save data and return to the workbook later and add more data.
    A user enters data into the template. In BeforeSave it gets the next consecutive number from another workbook , assigns it to this workbook and names this workbook accordingly.
    There is also a macro to upload the data collected to another summary workbook.

    At various times the worksheet is unprotected and reprotected via
    Sheet1.Protect Password:=DataSht.Range("pswrd"), DrawingObjects:=False
    SOMETIMES but NOT ALWAYS after saving or uploading the Listbox on the sheet will be deactivated. (You cannot click to multi select.) It has nothing to do with protection. I cannot determine the trigger.

    The ONLY way to reactivate the Listbox is on the Developer tab, click Design Mode TWICE. You don’t actually have to address the Listbox at all between the two clicks, just go into and out of Design mode. With the sheet protection on or off this Two Clicks does the job.

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Listbox is deactivated, no known cause

    Hello carsto,

    Unfortunately your issue is of such nature that we would not be able to assist you without a sample Workbook.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Contributor
    Join Date
    08-14-2006
    Location
    USA
    MS-Off Ver
    2019
    Posts
    686

    Re: Listbox is deactivated, no known cause

    I deleted ALL CODE and saved as .xlsx

    then resaved as .xlsm

    With nothing in the workbook except the Listbox and the Table containing the Listbox ListFillRange (which is a named range)

    when opening the file the Listbox is inactive until you click Design Mode TWICE
    Attached Files Attached Files

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Listbox is deactivated, no known cause

    I think the problem is the frozen panes, when I remove them the listbox seems to operate just fine.
    If posting code please use code tags, see here.

  5. #5
    Forum Contributor
    Join Date
    08-14-2006
    Location
    USA
    MS-Off Ver
    2019
    Posts
    686

    Re: Listbox is deactivated, no known cause

    Yet another reason to use Active X only when absolutely necessary.

    Solved the problem by using Split instead of Freeze Panes (yuck!) on the first row.

    I couldn't get a multiple column Listbox in the Forms Listbox.

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Listbox is deactivated, no known cause

    @ Norie,

    Well spotted Norie!

    @ carsto,

    Norie's observation is spot on! You cannot have any Control Boxes overlapping Freeze Panes Lines. The Control must be either inside or outside of the Freeze Panes Area/s.

    Cheers guys!

    W.

    Edit: Notice my post is a bit late. Always refresh before posting!LOL
    Last edited by Winon; 02-28-2017 at 06:47 PM. Reason: Explained "late posting"

+ 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] Deactivated options in Excels ribbon using Windows 10
    By Saturn in forum Excel General
    Replies: 4
    Last Post: 09-08-2015, 02:11 PM
  2. schedule deactivated clients can be filter out and pasted on the next tab.
    By Rajesh shishodia in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2015, 07:44 AM
  3. [SOLVED] Macro to be deactivated in specific ranges
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-23-2014, 05:40 AM
  4. [SOLVED] Macro deactivated in specific worksheet
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-22-2014, 01:25 PM
  5. [SOLVED] Delete worksheet if it is deactivated?
    By Alexander_Golinsky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-30-2013, 01:54 AM
  6. Code adjustment needed-warning message and highlighting is deactivated.
    By baffled1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-01-2011, 09:23 PM
  7. Worksheet_Deactivate procedure leaves me on the deactivated sheet
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2008, 05:21 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