Finally, I have another question:
I wrote your SetRefs procedure in ThisWorkbook, but my VBA have a lo
of UserForm, Modules. So I have to declare my variable in each userfor
and modules.

I understand that your answer is good for each procedure in a module
but I want to declare once to all my VBA (Workbook).

Is it clear enough

--
zapatista6

-----------------------------------------------------------------------
zapatista66's Profile: http://www.excelforum.com/member.php...fo&userid=1195
View this thread: http://www.excelforum.com/showthread.php?threadid=26698