Unexpected Error (419)

[searchlight]

Using Excel 2003

Sent a copy zipped to client using shared system and when the file is opended this message pops up.

Any ideas? Can't seem to find anything on this.

Thanks

 

[Joe4]

Is there any error description that comes up with the error message?

I saw some reference to 419 errors mentioning objects and ActiveX controls. Does the Excel file contain any VBA or ActiveX controls or other objects? They may not have the libraries containing those objects available or selected.

 

[searchlight]

Yes the message box has a header that reads Mocrosoft Visual Basic wit the 419 as the message.

I do have macros that perform a varied number of actions using a single userform for each sheet (Mon - Fri)

I have a macro that runs as soon as the workbook is opened to save the workbook (when first opened that week) with a unique name and/or sets the worksheet to the corresponding day of the week.

However that all works fine here on our shared system.

Note: I disabled the start up macro but now get An unexpected error has occured. AutoRecover has been disabled for this session of Excel.

Thanks

 

[Joe4]

Open the file on your system, go to the VB Editor, go to the Tools menu and select Refererences. Note all the References you have selected.

Now have the user who is experiencing the neighbor do the same. Are they missing any of these references? If so, that is probably the cause of the error.

 

[searchlight]

Thanks for the assist. It appears that the other user doesn't even have the ability in his network to chage the security settings. So we will have to talk to his IT to get this going i guess.

Thanks again.

 

[Joe4]

Yep, that could create problems if they cannot elect to enable your VBA code.