Hello,
BACKGROUND: I wrote an excel workbook that allows users to enter/maintain personnel data. It gets updated daily at 5 different work locations. The locations use the file to manage their specific personnel. It generates an attendance sheet and also a work summary sheet. They basically take the file for yesterday, make updates and save it for the new day. It serves as a plan for tomorrow and a record of yesterday. Personnel can be added/deleted and trucks change locations so the list is dynamic. We also have clerks that access the file to take care of the attendance sheet. They save the file as well. The excel files are saved on a network location in different files.
The work entry page utilizes about 100 activex combo boxes to select individuals and their vehicles to fill in the daily work summary sheet. The comboboxes listfillrange refers to a separate hidden page that has personnel names and trucks that are forced into alphabetical/numerical order by formulas.
I chose activex comboboxes because the list rows can be bigger (45 personnel), and the linked call allows the users to easily make wholesale changes to the schedule and makes the data entry very user friendly...auto complete and on and on.
PROBLEM: What is specifically happening...I save the file to the network location. A clerk accesses the file, make some changes and saves those changes. I go back in and access the file to make a file for the next day and it works fine. I save it, close it and we are all set. If I have to access the file again, I get "Can't exit design mode because Control "C60' can not be created" and the comboboxes have all been renamed. C60 is the name of one of the comboboxes. The clerk that was in the file earlier can access it and it works fine...no error message and comboboxes not renamed.
It affects some users and not others. I have renamed all of the comboboxes to unique names. All the other controls in the workbook are form controls. I have made sure all are saving as .xlsm. I have checked the trust center and observed what the users do when they access and save the file. Nothing of note. I have tried deleting the tmp files from the december 2014 issue that affected activex. At a loss.
Trying to roll this out on a large scale but won't until I get this glitch fixed. I need multiple users to have access and I really want to keep the activex comboboxes. I can do one time fixes, but can't sustain going back day after day to do that. HELLLLPPPPPP!!!!
BACKGROUND: I wrote an excel workbook that allows users to enter/maintain personnel data. It gets updated daily at 5 different work locations. The locations use the file to manage their specific personnel. It generates an attendance sheet and also a work summary sheet. They basically take the file for yesterday, make updates and save it for the new day. It serves as a plan for tomorrow and a record of yesterday. Personnel can be added/deleted and trucks change locations so the list is dynamic. We also have clerks that access the file to take care of the attendance sheet. They save the file as well. The excel files are saved on a network location in different files.
The work entry page utilizes about 100 activex combo boxes to select individuals and their vehicles to fill in the daily work summary sheet. The comboboxes listfillrange refers to a separate hidden page that has personnel names and trucks that are forced into alphabetical/numerical order by formulas.
I chose activex comboboxes because the list rows can be bigger (45 personnel), and the linked call allows the users to easily make wholesale changes to the schedule and makes the data entry very user friendly...auto complete and on and on.
PROBLEM: What is specifically happening...I save the file to the network location. A clerk accesses the file, make some changes and saves those changes. I go back in and access the file to make a file for the next day and it works fine. I save it, close it and we are all set. If I have to access the file again, I get "Can't exit design mode because Control "C60' can not be created" and the comboboxes have all been renamed. C60 is the name of one of the comboboxes. The clerk that was in the file earlier can access it and it works fine...no error message and comboboxes not renamed.
It affects some users and not others. I have renamed all of the comboboxes to unique names. All the other controls in the workbook are form controls. I have made sure all are saving as .xlsm. I have checked the trust center and observed what the users do when they access and save the file. Nothing of note. I have tried deleting the tmp files from the december 2014 issue that affected activex. At a loss.
Trying to roll this out on a large scale but won't until I get this glitch fixed. I need multiple users to have access and I really want to keep the activex comboboxes. I can do one time fixes, but can't sustain going back day after day to do that. HELLLLPPPPPP!!!!