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
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
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
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
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!!