Locking design mode, VBA and textboxes

[Submeg]

Hello all,

I have created a calculator which predicts a value depending on other values entered by the user.

The user first select a day from a drop down combobox (form control, not active x). They then select the number of days from another form control combox box. After pressing an ActiveX Command Button, a module calculates what days are affected (for example, if the user selects "Wednesday" and the length of 3 days, the days activated are: Wednesday, Thursday and Friday)

These strings are then displayed in ActiveX Textbox that the user cannot enter data into. The user then enters minimum and maximum temperatures for those days in other ActiveX Textboxes which have not been disabled. After pressing another ActiveX Command Button, the modules calculate a number depending on the number of days, temperatures etc...

My question is this. I have protected the sheet from users entering data into cells, I have stopped them from opening VBA, but I also want to stop them from shifting a textbox that I have on the page and from entering designmode.

I have tried to protect the sheet, but in doing so, it stops the user from selecting any of the values in the dropdown combo boxes.

I also trying to lock the design mode buttons using:

CommandBars("Visual Basic").Controls("Design Mode").Enabled = False
CommandBars("Control Toolbox").Controls("Design Mode").Enabled = False

On opening the the workbook. However, excel returns:

"Run-time error '91': Object variable or With block variable not set."

Any ideas on how to solve these? Cheers!!