Userform problem with "Run Time Error 75"

[boggimedes]

I am surprised as well, though I suppose it is probably much less commo
that people use sheets where they open and close userforms. Plus I ha
a really hard time figuring out it was a userform issue. I thought i
just crashed randomly at first. Then I realized it was any time
saved (or it autosaved). Still was some time before I noticed th
pattern. Anyway, DO have a solution, though its not the best one.

Office 2010 beta is out, and it resolves the issue. Just proves onc
and for all that it is nothing to do with how we coded. Must b
something in the way 2007 handles userforms that they changed in the ne
version. Doubtful that MS will try to fix it in 07 now that 10is on th
horizon. Looks like we'll all just have to upgrade.... again.

Hey, at least its fixed somehow! I'll keep myself on th
notification list for this forum just in case someone else smarter tha
I finds a solution.

 

[Dave Unger]

Hi boggimedes

Thanks for the heads up re Office 2010. You're probably right about
"updating" to fix a microsoft problem, but as you suggest, what choice
do we have?

regards,

DaveU