ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   marco problem in excel 97 (https://www.excelbanter.com/excel-programming/358665-marco-problem-excel-97-a.html)

Jimmy

marco problem in excel 97
 
hi,

i have a question about excel 97. how put the marco in the excel file when
it is new ??

thanks
jimmy



windsurferLA

marco problem in excel 97
 
To create macro module in Excel97

Easiest approach… record a simple macro… it will create a module and
provide a sample showing the minimum elements of a macor.

Direct approach. . Press Alt-F11 to open Visual Basic Editor, Then use
menu bar to INSERT/ MODULE


Jimmy wrote:
hi,

i have a question about excel 97. how put the marco in the excel file when
it is new ??

thanks
jimmy



Jimmy

marco problem in excel 97
 
Thank for your reply

But I means that I have already created a marco, I want to use it when I
create a New excel file.

Thanks
Jimmy

"windsurferLA" wrote in message
...
To create macro module in Excel97

Easiest approach… record a simple macro… it will create a module and
provide a sample showing the minimum elements of a macor.

Direct approach. . Press Alt-F11 to open Visual Basic Editor, Then use
menu bar to INSERT/ MODULE


Jimmy wrote:
hi,

i have a question about excel 97. how put the marco in the excel file
when it is new ??

thanks
jimmy




All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com