View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.programming
HSalim[MVP] HSalim[MVP] is offline
external usenet poster
 
Posts: 70
Default Creating an add-in

I see that you have already provided the answer to my latest question in
your first post on this subject.
I don't need to close the add-in - that will happen when the user quits
excel at the end of the day.
Ok, I won't delete the toolbar on close, so the addin loads when the user
clicks on one of the toolbar buttons.

All good, but why do you say this is non-standard? and what would be a
better way to distribute this add-in?

Again, thanks the help.

Regards
Habib

"Peter T" <peter_t@discussions wrote in message
...
: Hi HAbib,
:
: Referring to your OP perhaps you don't want to delete the toolbar when the
: addin unloads. If so don't set the toolbar's Temporary property True and
: don't delete in the file's close event.
:
: With this arrangement it's NOT necessary to install the addin into the
addin
: manager (with code or with user Tools / Options / Addins.).
:
: When user clicks on your toolbar if your addin is not already loaded it
will
: automatically load.
:
: You could have an additional button linking to a routine to close the
addin
: if no longer required in the current session. Maybe also make the toolbar
: invisible on unload, eg when Excel closes if not before.
:
: In the open routine test if your toolbar exists, if not create it, if it
: does check it is all correct. There are plenty of unused icons that if
: suitable might avoid necessity of creating custom icons.
:
: Advise user to simply double click the addin in it's folder first time to
: load and create the toolbar. When user closes Excel there should be no
other
: running instances to ensure it gets stored in user's toolbar / *.xlb
file).
:
: This is certainly NOT the normal way to distribute an addin and could
: antagonise users. However it might fit your user's particular
requirements,
: a) knows how to make the toolbar visible, b) infrequent use (addin only
gets
: loaded when specifically required), c) knows how to recover the toolbar if
: it accidentally gets deleted (load addin from file).
:
: Regards,
: Peter T
:
: "HSalim[MVP]" wrote in message
: ...
: Tom,
:
: Thanks for the super-fast reply, and for all the links.
: I did find Jan Karel's site, and have been trying to follow his advice.
:
: I cant put my finger on what I am doing wrong, but I think I am
: permanently
: deleting the toolbar.
: I've had to recreate my toolbar a few times now as I seem to delete it.
: Is there a way to backup a toolbar?
: I could create the toolbar in code like JKP does - perhaps that is the
: answer.
: How do I save the button images so that I can create the toolbar with
the
: images I want?
:
: REgards
: HAbib
:
:
: "Tom Ogilvy" wrote in message
: ...
: : http://support.microsoft.com/?id=167909
: : XL: Securing Visual Basic Code in Microsoft Excel
: :
: : http://support.microsoft.com/?id=156942
: : XL97: How to Create an Add-in File in Microsoft Excel 97
: :
: : http://support.microsoft.com/?id=211563
: : How to create an add-in file in Excel 2000
: :
: :
http://msdn.microsoft.com/library/en...xceladdins.asp
: :
: :
:
:
http://msdn.microsoft.com/library/en...tingexceladdin.
: asp
: :
: : http://www.j-walk.com/ss/excel/tips/tip45.htm
: : Excel 97: Creating Add-Ins
: :
: : You addin should delete any existing version of the toolbar and create
a
: new
: : version when it is loaded. It should also mark it as temporary and
: delete
: it
: : in the beforeclose event. The creation can be done in the
: workbook_open
: : event of the addin.
: :
: : If the user will only load the addin when they want to use it, then
this
: : should be sufficient. If they will load the addin all the time, then
it
: : depends on the user. In tools=Customize, they can select whether the
: bar
: : is visible or not. If that is too hard, then perhaps you could
provide
: a
: : function in your addin that they can run from Tools=Macro=Macros or
: you
: : can add an additional menu choice in the tools menu.
: :
: : --
: : Regards,
: : Tom Ogilvy
: :
: :
: :
: : "HSalim[MVP]" wrote in message
: : ...
: : How do I create an add-in and distribute it to others?
: : I have a toolbar associated with the add-in. The user wants the
: toolbar
: : to
: : be invisible most of the time. When she wants to use the add-in -
: : approximately once a month, she will make the toolbar visible.
: : What is the best way to achieve this?
: : Thanks
: : Habib
: :
: :
: :
: :
:
:
:
: