les_austin
New Member
- Joined
- Oct 9, 2002
- Messages
- 10
Hi all,
I inherited a excel spreadsheet that contained two macros. One a simple printing macro, no worries there. Another was run by ‘CTRL & C’, the function was to lookup a defined month (e.g. user enters 6 for June) move to the section of the month in question, copy the data in that section and place it into a current month area. A report was generete off the current month information. Hope this explains. The problem is the macro never appeared in tools/macro/macros option. But it worked fine. Since moving to Excel 2000 the ‘CTRL C’ fails to work.
Firstly, does any one know where I would find the macro and its code?
Secondly, why does the macro not run in Excel 2000?
Thirdly, If all fails is there much involved in rewriting the macro, any suggestions
I am sorry my first post is so long winded, but this has me stumped.
My regards to all
I inherited a excel spreadsheet that contained two macros. One a simple printing macro, no worries there. Another was run by ‘CTRL & C’, the function was to lookup a defined month (e.g. user enters 6 for June) move to the section of the month in question, copy the data in that section and place it into a current month area. A report was generete off the current month information. Hope this explains. The problem is the macro never appeared in tools/macro/macros option. But it worked fine. Since moving to Excel 2000 the ‘CTRL C’ fails to work.
Firstly, does any one know where I would find the macro and its code?
Secondly, why does the macro not run in Excel 2000?
Thirdly, If all fails is there much involved in rewriting the macro, any suggestions
I am sorry my first post is so long winded, but this has me stumped.
My regards to all