Thread: AddIn
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robin Clay[_2_] Robin Clay[_2_] is offline
external usenet poster
 
Posts: 14
Default AddIn

Grateful thanks to both Myrna Larson and Tom Ogilvy

Myrna wrote
Do you have Rob Bovey's Code Cleaner?


and Tom responded
Rob Bovey's URL:
http://www.appspro.com


So thither I went, and fetched it down, and ran it.

Now when I fire up Excel, there is the Code Cleaner
attached, and it immediately generates an error -

Run-time Error '1004':
Method 'VBE' of object '_Application' failed

on this (the last) line of Auto_Open

''' Create the VBE menu.
Set gclsMenuHandler = New CMenuHandler

NOT a very auspicious beginning....