Hi forum,
Encouraged by a solution provided here a couple of days ago I now present a new challenge in the same giant workbook of mine:
The controlSource property of any of my textboxes and combo boxes in a user form produces and "Excepion occurred", preventing the user from giving and storing input. All of the boxes have ControlSource properties that point to named ranges (single cells) in the workbook.
There is this template file (.xltm). When first opened (and possible stored as .xlsm) it produces this error. The only thing that helps is actually closing Excel and restarting the computer !
After that I haven't observed the error when working in the .xlsm file.
As far as I know there is no protection in the workbook. Can someone shed some light on this issue?
Terje
Encouraged by a solution provided here a couple of days ago I now present a new challenge in the same giant workbook of mine:
The controlSource property of any of my textboxes and combo boxes in a user form produces and "Excepion occurred", preventing the user from giving and storing input. All of the boxes have ControlSource properties that point to named ranges (single cells) in the workbook.
There is this template file (.xltm). When first opened (and possible stored as .xlsm) it produces this error. The only thing that helps is actually closing Excel and restarting the computer !
After that I haven't observed the error when working in the .xlsm file.
As far as I know there is no protection in the workbook. Can someone shed some light on this issue?
Terje
