code cleaner
 

The workbook I am working on has expanded to 7.5M after removing all
unused ranges using the last used cell approach as discussed on
several posts here, so I am now trying to reduce the file size using
Rob Bovey's code cleaner. I have installed it and read through the
help but I seem to be missing something. I have added the com addins
button but when I hit ok with Code cleaner ticked nothing happens. I
also have tried running the Public Sub CleanAllProjects() macro from
the example file whilst having the files open I am attempting to clean
but I get an error message "Method 'VBE' of object'_Application'
failed."

I realise I am doing something wrong bit cant figure out what. Could
someone provide an idiots guide to running the code cleaner.

Many thanks for any advice.

Regards

JAmie

code cleaner
 

I find mine by Tools|Clean Project

" wrote:

The workbook I am working on has expanded to 7.5M after removing all
unused ranges using the last used cell approach as discussed on
several posts here, so I am now trying to reduce the file size using
Rob Bovey's code cleaner. I have installed it and read through the
help but I seem to be missing something. I have added the com addins
button but when I hit ok with Code cleaner ticked nothing happens. I
also have tried running the Public Sub CleanAllProjects() macro from
the example file whilst having the files open I am attempting to clean
but I get an error message "Method 'VBE' of object'_Application'
failed."

I realise I am doing something wrong bit cant figure out what. Could
someone provide an idiots guide to running the code cleaner.

Many thanks for any advice.

Regards

JAmie