Macros disappear once created -

Posted on 2008-02-12
Medium Priority
Last Modified: 2008-03-06
When Macros is created in either Word or Excel is disappears when restarting either program. When I try to look for the macros it's as if I never created the macro.
Question by:rwilder25
LVL 14

Expert Comment

ID: 20879066
Are you saving the files before exiting?  The macros are part of the documents, not application-wide.

Author Comment

ID: 20879581
I'm putting them in my personal Macros Workbook
LVL 81

Expert Comment

ID: 20880275
You have to save Personal.xls as part of closing Excel--otherwise the macro will be lost. You should be getting a prompt to do that.
LVL 77

Accepted Solution

GrahamSkan earned 750 total points
ID: 20882924
In Word, where do you write the macros? In the Normal template?
There may be a problem with saving or opening the template.
Check the dates of any normal.dot files in the folders given in Tools/Options, File locations tab - User templates and Workgroup templates.

Author Comment

ID: 20884528
I'm going to give this to Craig, IT, and ask him to deciper this geekense (I don't get it). Thanks for the help.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an article on how to answer questions, earn points and become an expert.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question