You are an absolute genius Rod.
I did a search for visual basic commands and came up with a lot of
commands that didn't work. Didn't think of doing a search with the term
you used.
I have used this macro for years after many new installations of Windows
and Office but just couldn't remember how I got it to work.
Saving macros in Word is easy and are saved to the Normal.dot file but
was unable to find the equivalent in Excel.
Thanks muchly.
Neville.
On 30/03/2014 3:30 PM, Rod Hutton wrote:
Hi Neville,
A quick google found the following URL:
http://answers.microsoft.com/en-us/office/forum/office_2003-customize/excel-2003-saving-macros-for-use-in-multiple/fea92a13-bbc2-45bc-b26f-926be3895999
hth,
Rod
On 3/30/14 1:09 AM, Neville wrote:
Hi Listers,
Using W7 HP 32, Office 2003 and latest WE
Hopefully someone can inform me of the solution to my probem.
IHave written a macro for Excel 2003 for adding an amount to the
current cell but don't know how to save it. The macro has been
created with a name and hot key, edited and tested.
When being edited, I think the macro is loaded into Visual Basic and
probably needs to be saved using VB commands. There is nothing on
the screen to inform me how to save the macro so when Excel is closed
and restarted, the macro is not available.
Does anyone know how the macro can be saved for future use?
Thanks
Neville.
If you reply to this message it will be delivered to the original
sender only. If your reply would benefit others on the list and your
message is related to GW Micro, then please consider sending your
message to [email protected] so the entire list will receive it.
GW-Info messages are archived at http://www.gwmicro.com/gwinfo. You
can manage your list subscription at http://www.gwmicro.com/listserv.
If you reply to this message it will be delivered to the original sender only.
If your reply would benefit others on the list and your message is related to
GW Micro, then please consider sending your message to [email protected] so
the entire list will receive it.
GW-Info messages are archived at http://www.gwmicro.com/gwinfo. You can manage
your list subscription at http://www.gwmicro.com/listserv.
