How to globally get Macros to work around "Protected" /Locked Worksheets and Workbooks

It works... there is only one function that doesn't while under protection. And that's a ComboBox. As long as the "Cell Link" is locked. It can't work. So, anything to get around this? Perhaps assign a Macro to the ComboBox??? I dunno?

Thanks!