PC Review


Reply
Thread Tools Rate Thread

Close 2007 add-in from code

 
 
=?Utf-8?B?Y2hyaXM=?=
Guest
Posts: n/a
 
      30th Apr 2007
Hi,

In my Office 2007 excel add-in ribbon, I have a button for closing add-in.
What command shall I use for closing only this add-in and keeping excel open ?

Thanks a lot in advance!
 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      30th Apr 2007
If the code is in the addin, just use

ThisWorkbook.Close

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"chris" <(E-Mail Removed)> wrote in message
news:64423747-44B2-4AD3-BCCE-(E-Mail Removed)...
> Hi,
>
> In my Office 2007 excel add-in ribbon, I have a button for closing add-in.
> What command shall I use for closing only this add-in and keeping excel
> open ?
>
> Thanks a lot in advance!



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2007 Disable Close and Close All on Tabbed Documents MumHeb Windows Vista 0 6th May 2010 05:36 PM
Close Code possible? LiAD Microsoft Excel Programming 3 27th Apr 2009 10:13 AM
close code =?Utf-8?B?U2hhd24=?= Microsoft Excel Programming 1 20th Sep 2005 02:49 PM
Close VB in Code Paul Watkins Microsoft Excel Programming 2 17th Dec 2003 09:25 PM
code to close fordge Microsoft Excel Misc 1 25th Nov 2003 09:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:34 PM.