Macros will run in a shared workbook, including macros that show a userform.
I think there's something else going on with your code. "Run time error
1004" is very generic; what was the text of the error message?

--
Jim Rech
Excel MVP
"Tove Ditmansen" wrote in message
...
|I need to know if it's possible to use a userform if you have a shared
| workbook (excel).
| I get et message "Run time error 1004"
|
| Can anybody help?
|
| TD
|
|
|