distributing an Excel/VBA app

[rickalty]

I need to send an Excel spreadsheet that I have programmed with quite a
bit of code to a number of my companies offices. I really don't want to
have to explain to non-excel-literate office staff all over the place
that they should go tools / macros / run / etc etc to make it run, but
nor do I want it to auto-execute because these people all use Excel for
numerous other functions. I thought that custom toolbar buttons would
'travel' with the spreadsheet, but apparently not. Any suggestions?

Richard

 

[dok112]

you would have to tell the app to "build" the toolbar each time it was
opened. You could also put a open command in the Workbook_Open so it
will only open when this particular workbook opens.

 

[Ed]

What I wound up doing once was putting all the special commands as
CommandButtons on a separate worksheet. That way you can include a brief
explanation of what each one does. Then create one new sheet as a "splash
page" - it has a large brightly colored box explaining that macros must be
enabled to use this workbook - and set the other sheets as Hidden or even
VeryHidden. In an AutoOpen macro, the splash sheet is hidden and the other
sheets are shown, provided the user has enabled macros. You can then use
the Close event to reset the working sheets to Hidden and the splash page as
visible.

HTH
Ed