ActiveX Text Box causing crashes

Will S

Board Regular
Joined
Oct 29, 2013
Messages
69
I've got a major issue with all the activeX Text boxes on my sheet, it seems whenever the part of the sheet that text box is in, is hidden, it completely screws up. It changes it's background colour to the border colour and when you hover the mouse over it, it immediately crashes the workbook.

I'm not 100% sure if it's only when the cells it is in are hidden, but I'll be trying to see if changing any of the properties help with this. I noticed it shortly after printing so it might have something to do with that, I'm really confused and it's making the sheet I've got unusable. Can anyone give any advice for this?

Best regards,
~Will S
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
I think I've managed to sort the issue, it was because the text boxes were set to "Move and Size with Cells" Now I've changed them to Move but don't size everything seems fine.
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,915
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top