Opening User Forms

[pengiliverpool]

i have designed a userform and everything works ok on my computer. to view the form a macro has been recorded to a button with the code, userform1.show. this macro is called showform().
when somone else tries to view the form they are greeted with an error, when you click debug the error is the macro to open the form. can anyone shed any light on this?
i cant understand why i can use this but nobody else can
thank you

[debasisdas]

Kindly post what exactly is the error message.

[pengiliverpool]

when the button is clicked to display the form the error reads.
Run-Time error '1004':
Application defined or object-defined error

when you debug the error is in the macro:

Sub ShowForm()
UserForm1.Show
End Sub

and the userform1.show line is highlighted.
any help wiould be greatfully apreciated

[hariharanmca]

application defined or object defined error
Will this helpfull for you.

[pengiliverpool]

hi i have had a look at this and downloaded some other files for the other users who will access this workbook and form. it still doesnt work. i work in an office so all computers have the same spec and files included. the form works perfectly for me but nobody else can use it

[pengiliverpool]

i have sent the file to my home pc and it works but still doesnt on the other office pc's we have tried various releases of windows and excel with no joy, any ideas please