DeleteModuleContent doesn´t work in some computers...
 

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

DeleteModuleContent doesn´t work in some computers...
 

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