+ Reply to Thread
Results 1 to 5 of 5

Error on saving: ActiveX listbox "does not support saving"

  1. #1
    Forum Contributor
    Join Date
    05-24-2006
    Location
    Los Angeles
    MS-Off Ver
    2019
    Posts
    328

    Error on saving: ActiveX listbox "does not support saving"

    Has anyone every seen this error before and know of a solution?

    when saving the file, I get the error message:
    "Microsoft cannot save this workbook because the control named lstDatabase does not support saving. To save the workbook, delete this control, and then try save again."


    The listbox in question works perfectly, then suddenly it doesn't.

    Lawrence

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Error on saving: ActiveX listbox "does not support saving"

    How are you assigning the values to the listbox?

    A few messages I found suggest that dynamic ranges are complicit someway.
    David
    (*) Reputation points appreciated.

  3. #3
    Forum Contributor
    Join Date
    05-24-2006
    Location
    Los Angeles
    MS-Off Ver
    2019
    Posts
    328

    Re: Error on saving: ActiveX listbox "does not support saving"

    The listboxes that Excel asks to be delete are populated by a macro using a dynamic range in List method.

    However, I suspect that there may be a ListBox conflict... The listboxes that are asked to be deleted are ActiveX controls on a sheet, and there are other listboxes on a UserForm activated from another sheet. Need to do some testing, but suspect when that UserForm is launched ON THE SAME SHEET as the ActiveX listbox is when the problem arises.

    Could that be a possibility???

    Lawrence

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Error on saving: ActiveX listbox "does not support saving"

    It could, especially if you're using the default names and you are not using fully qualified references. Sheet1.Listbox1... or userform1.Listbox1.

  5. #5
    Forum Contributor
    Join Date
    05-24-2006
    Location
    Los Angeles
    MS-Off Ver
    2019
    Posts
    328

    Re: Error on saving: ActiveX listbox "does not support saving"

    Cool. I've qualified the listboxe names...seems like a that may be the source of the problem. I'll will keep you posted.

    Lawrence

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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