I have a spreadsheet which I send to 260 people which is read-only (for them)
call it MASTER and I have functions which only I as Admin of MASTER need to
perform on the sheet. To try to minimise the size of the sheet I decided to
seperate the admin functions to an ADD-IN (say ADMIN.XLA). I have created the
add-in and a menu to call the functions but the only way I could find to get
the SUBS in ADMIN.XLA to run (from the add-in menu) when working in MASTER
was to create a reference in the original s/sheet from the VBE. It seems to
work ok and the MASTER still works OK for users and myself but have I
achieved anything? It's no smaller! Have I gone wrong with my ADD-IN? It is
my first!