Judge,
_http://www.informit.com/guides/content.aspx?g=msoffice&seqNum=162
Цитата:
Sharing Your Macros
OK, so now what about if this macro is really cool and someone else wants to use it? Saving the Excel file (XLS) won't preserve the macro, because macros are attached to the template from which the file is derived.
The solution is to save the file as an XLT (Excel template file). Here's the trick: Excel will try to put that template file into your default Templates folder; you should probably put it elsewhere in order to facilitate moving the file. (We covered the actual location of the default Templates folder in "Planning for Disaster.")
Figure 661
So if we save this template file locally, and move it elsewhere, what do we get?
First, we get a warning message about the fact that there are macros in this file, and do we want to enable them? To do so, we need to go into the Tools > Options dialog box. In the Security tab, click the Macros button and set the security macro to at least Medium.
|
попробуй отсюда. (я не все процитировал)