RunTime Error 424 Object Required

MikeDBMan

Well-known Member
Joined
Nov 10, 2010
Messages
580
I spent all day creating a spreadsheet for someone but every other computer in the whole company we've tried this file on Excel crashes when I try to use it. About the only thing I did differently than I've done many, many times before is I put a bunch of checkbox activex controls on a sheet. And I created a bunch of UDF's (User Defined Functions) to determine what is checked and what is not checked. The Error 424 comes up if they try to execute anything from within the VBA editor. On the sheet where most all the checkboxes are located, they cannot even select a component. If I go to design mode, they can select the item but the properties window yields the sheet, not the activex control. This is very frustrating. Does anyone have any suggestions. If I hit Recalc, Excel stops working!
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

MikeDBMan

Well-known Member
Joined
Nov 10, 2010
Messages
580
Thanks Rory. I had forgotten about this. Obviously I had run that fix on my PC back in December as I recall so it was working for me. I have asked my user to run it on his PC as well. Thanks for helping jog my memory. I am glad I was not going crazy as it only worked on my PC!
 

Watch MrExcel Video

Forum statistics

Threads
1,095,534
Messages
5,445,047
Members
405,308
Latest member
kiteman112000

This Week's Hot Topics

Top