Display something on first open only.

  • Thread starter Thread starter PaulW
  • Start date Start date
P

PaulW

Hello.

I've been creating and modifying a series of Userforms in an addon for quite
sometime, and am currently looking at getting the IT Department to help me
load this addon into everyones addon folder and allow me access to update it
as and when I need/want to.
Currently I have to load the addon manually using browse, and updating it is
too tricky for someone else to do, hopefully this will solve these problems.

But anyway, what I'm wanting is to have a messagebox, or a userform, or
something appear the first time they open Excel with the addon installed. And
then for it to never appear again, then when I update something I can have it
appear again letting people know any changes, but I don't want it appearing
every time they open Excel, just the first time that version of the addon
loads...

I honestly don't have the first clue where to start... or even if I can do
it...
 
Rather than getting IT to mess with everyone's computer, place your add-in on
a shared network public folder. Then, instruct everyone to load the add-in
from the network location. (Alternatively, you can program a macro to load
the add-in from a stanard workbook.)

With the add-in on the network, everyone can have the most up to date copy
upon starting Excel. You, however, should use a private copy of the add-in
so you can continue development without interfering with others. Then,
whenever you need to update your code, you need only overwrite the public
version of the add-in. This is how I handle public add-ins at work.

More information about distributing code can be found here:
http://www.jkp-ads.com/Articles/DistributeMacro00.htm

Matthew Pfluger
 
Back
Top