LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default closing a vba project - dumb question

I know this is likely to be a dumb question but for all my searching I
cannot find an answer.

You can open a project (in my case one of my excel add-in files) by
double clicking on it - and the filename will be added to the Project
Explorer window in VB, along with all it's modules etc. But how do
you go about closing that add-in file once it is open? The only way I
found was to (save changes to all the other open projects, and) close
excel entirely, then open it again.

Another way I found was to find "ThisWorkbook" and change the
"IsAddin" property to FALSE, which opens the workbook in excel which I
can then close.

Is there an easier way to close a project?
 
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
Dumb Question Oldjay Excel Programming 2 July 29th 07 05:58 PM
Dumb Question David Excel Worksheet Functions 2 May 28th 07 08:13 PM
dumb question uw805 Excel Worksheet Functions 6 June 8th 06 05:06 PM
Very dumb question gregorsamsa Excel Discussion (Misc queries) 2 March 23rd 06 03:15 PM
Dumb Dim Question Michael Smith Excel Programming 1 June 25th 04 05:43 PM


All times are GMT +1. The time now is 06:43 AM.

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"