Copy Macros from Disk to Excel
Posted by Melia on December 22, 1999 11:47 AM
Ok this is probably fairly basic, but I'm new to Excel - I have a disk with some macros on it that I need to put into Excel on my boss' computer. I've copied them into the XLStart folder. Now they load up automatically when I open Excel, and not all of them are there.Should they be loading automatically? Or am I completely off-base. Also, when I go to try and use one of them I get errors saying the workbook is hidden, then when I 'unhide' it, it fills up the screen with what looks like the source code for the cells instead of the actual pie-chart or graph that it should be. Help :(
Melia
Posted by Chris on December 23, 1999 5:18 AM
Melia,
The "macros" you copied to the XLStart directory exist in either an xls or xla format (most likely). Any file that resides in the XLStart directory will automatically open with Excel. These files are saved as hidden so that they it appears transparent to the user. Usually they are in a file called Personal.xls. What do mean by certain ones missing? When you pick Tools|Macro|Macros the list is missing them? If that is the case, either they aren't in the files, or they are listed as a Private Sub (one called from another macro), or it is a function (which won't show up under macros).
The issue of the error graphing the pie chart is either user error or a macro problem. The macro may need to have a range selected to draw the graph, or the macro is trying to create the chart in the hidden workbook. You will likely have to find someone who knows VBA to fix that one.
Good Luck,
Chris
