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.
Bookmarks