By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,646 Members | 2,063 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,646 IT Pros & Developers. It's quick & easy.

Opening User Forms

P: 9
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
Nov 29 '07 #1
Share this Question
Share on Google+
5 Replies


debasisdas
Expert 5K+
P: 8,127
Kindly post what exactly is the error message.
Nov 29 '07 #2

P: 9
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
Nov 29 '07 #3

hariharanmca
100+
P: 1,977
application defined or object defined error
Will this helpfull for you.
Nov 29 '07 #4

P: 9
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
Nov 29 '07 #5

P: 9
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
Nov 29 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.