I'd check the references on the computers where it doesn't work. I suspect
one is missing.
I believe I use the reference
Microsoft Visual Basic for Applications Extensibility 5.3
when I do something like this and I believe I had to download it. I also
had to trust the VBA project when I do things like this, which I wouldn't
recommend to the casual user.
HTH,
Barb Reinhardt
"SpeeD" wrote:
hi to all!
i have the following code in my WB that deletes the VB content from one of
my sheets.
The problem is that in some computers (Running Vista) the code dosen´t work!
but in my Pc and others works just fine!
nome = Worksheets("Sixt - Tabela 1").CodeName
DeleteModuleContent ActiveWorkbook, nome
What´s happening? what am i doing wrong?? do i have to call an external
reference?
Thanks a Lot!!!
SpeeD