Userform not working on all computers

[Hoozits]

I have this code

Private Sub Worksheet_Calculate()
frm_document.Show
End Sub

A userform is called up upon a calculation change in the spreadsheet on two computers and has for years. We just hired a new employee and the userform is not pulling up for her. Instead she gets an error: Runtime error 75...Could not find the specified object. Any ideas?

 

[Hoozits]

I tried it. I'll let you know if it works. One can dream.

 

[Colin Legg]

I'd just close Excel down completely then re-open the Excel application afresh with a blank workbook.

Then Tools | Addins and untick (ie. uninstall) all the addins. Click OK.
Then Tools | Addins and retick (ie. install) the addins. Click OK.

Then try opening and running your workbook.


To be honest, I really don't hold high hopes with this!

 

[RoryA]

Someone is going to install Excel locally onto her machine as that has not been done before.

What exactly do you mean by that? Are you running Citrix or something?

 

[Hoozits]

You know, I don't know what I mean by that. I'm just quoting you what was told to me by our Helpdesk. Whatever it means, excel was installed locally on my machine, but not the colleague's for which this problem is occurring.

 

[Hoozits]

Be it uninstalling the addins and installing them again or installing excel 'locally' on her machinge, who knows, but the problem has been resolved after both were done. Thanks to all who offered their help. Your time and talents and knowledge, etc., are all very much appreciated.