Microsoft Visual Basic error message when trying to print Excel user form

[cpieramico]

I have created an Excel user form that uses VBA code to push the form data into a hidden worksheet within the existing workbook when the user clicks a command button. Once the data is pushed to the worksheet a print dialog box pops up so the user can select a printer to print the form to. This has been working fine for most users, however I learned recently that some users at a particular location are receiving the following errors message when they click the command button:

Run-time error '1004':
Method 'Worksheets' of object '_Global' failed

I have been unable to troubleshoot this issue.

Below is the code that I am using:

Please Login or Register  to view this content.

[Arkadi]

Generally can't print a hidden sheet... unhide, print, and re-hide?
If that's not the issue then the sheet name may be incorrect. I can't find you actual print code so I can't guess any other reason.
Additionally please use code tags when posting code. Highlight what is code and hit the # icon.

[Norie]

Where do you get the error?

[cpieramico]

They are getting the error when they click command button cmdadd.

[Norie]

Which line of code is the error ocurring on?

[cpieramico]

I am unable to answer that. The users who are experiencing this issue are not at my location and on my computer it works just fine.

I'm thinking it has something to do with other settings on their computer and not the VBA code itself. I know that they are running Excel 2003 but I have other users on Excel 2003 who can print the forms without any issues.

[Arkadi]

Ah, any chance they have renamed a sheet?

[cpieramico]

No, that is not possible. The worksheets are hidden using the "very hidden" option and I doubt that anyone knows anything about using VBA. Plus, the file is shared by all employees so if a worksheet had been renamed the form wouldn't work for anyone.