Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 788
Default Close 2007 add-in from code

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!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default Close 2007 add-in from code

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" wrote in message
...
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
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
how to close app in code? homer Excel Programming 3 October 5th 05 06:33 PM
VBA Code req to close all workbooks Neil Atkinson Excel Programming 0 September 23rd 05 11:06 AM
close code Shawn Excel Programming 1 September 20th 05 02:49 PM
close form code tkaplan Excel Discussion (Misc queries) 1 June 3rd 05 10:49 PM
Close VB in Code Paul Watkins[_2_] Excel Programming 2 December 17th 03 09:25 PM


All times are GMT +1. The time now is 02:13 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"