Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / May 2008

Tip: Looking for answers? Try searching our database.

.xla information tab

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mark - 30 May 2008 20:57 GMT
Hello.

When you select a seeded Add-in, such as the Analysis ToolPak - VBA, the
frame at the bottom shows the Add-In's name as it's title, and offers a
description... in this case, "VBA functions for Analysis toolPak".

How do you put that description in for a custom Add-In?

I've tried put something in the Tools - VBA Project Properties - Project
Description text box, but apparently that's not the right place.

Thanks,
Mark
Dave Peterson - 30 May 2008 21:29 GMT
I find this the easiest way:

Open windows explorer
Traverse to the folder that holds the addin
Select the addin and rightclick on it.
Choose properties
On the Summary tab, you can change the:
Title and Comment.
(either in the simple or advanced dialog)

The title will be what you see in the listbox.  You'll see the comment at the
bottom of that dialog.

> Hello.
>
[quoted text clipped - 9 lines]
> Thanks,
> Mark

Signature

Dave Peterson

Rob Bovey - 30 May 2008 21:30 GMT
Hi Mark,

   The information displayed by the Tools > Add-Ins dialog is read from the
Excel workbook properties. Turn the IsAddIn property of your XLA to False so
you can see the workbook. In the Excel user interface choose File >
Properties from the menu to get the Properties dialog.

   On the Summary tab of the Properties dialog the Title entry is used as
the list entry for your add-in in the Add-Ins dialog list and the Comments
entry is displayed at the bottom of the Add-Ins dialog when you select the
entry for your add-in from the list.

Signature

Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

> Hello.
>
[quoted text clipped - 9 lines]
> Thanks,
> Mark
mark - 30 May 2008 21:44 GMT
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.