#1   Report Post  
Posted to microsoft.public.excel.programming
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....
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
AddIn Excel2007 William Wolfe[_2_] Excel Discussion (Misc queries) 0 February 2nd 10 08:28 PM
How to close an Addin? FARAZ QURESHI Excel Discussion (Misc queries) 5 June 4th 09 01:15 PM
MS VB addin err DL Excel Worksheet Functions 0 May 15th 07 05:22 PM
Addin Help alexm999 Excel Discussion (Misc queries) 4 July 25th 06 08:27 PM
Addin Password Adept Excel Discussion (Misc queries) 1 March 9th 06 10:22 PM


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"