Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Excel IV macro sheet

How do I insert an Excel IV macrosheet into an Excel 2003 workbook? There was
a pull down menu that allowed the insertion of a macro sheet but that is no
longer an option. I have enabled the Excel IV language by copying a 15 year
old Excel IV application with macro sheet to an Excel 2003 workbook, and
overtyping the contents of both the spreadsheet and the macro sheet to create
a new application. Is there an easier way? I don't particularly like Visual
Basic and don't want to learn it.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default Excel IV macro sheet

Right click on the sheet tab and choose insert. A macro sheet is an option
under that.

--
Regards,
Tom Ogilvy


"Maxie" wrote:

How do I insert an Excel IV macrosheet into an Excel 2003 workbook? There was
a pull down menu that allowed the insertion of a macro sheet but that is no
longer an option. I have enabled the Excel IV language by copying a 15 year
old Excel IV application with macro sheet to an Excel 2003 workbook, and
overtyping the contents of both the spreadsheet and the macro sheet to create
a new application. Is there an easier way? I don't particularly like Visual
Basic and don't want to learn it.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Excel IV macro sheet

Thanks Tom, I create my own spreadsheets for Federal and State Income taxes
which I update each year to reflect the changes. This year I wanted to add a
"Print" button to each form. Your reply will help immensely since I have
about 8 Federal and State forms and several other worksheets in the workbook.

M R J (Maxie)

P.S. I wrote my first computer program at Stanford Univ in 1957 on an IBM 650.

"Tom Ogilvy" wrote:

Right click on the sheet tab and choose insert. A macro sheet is an option
under that.

--
Regards,
Tom Ogilvy


"Maxie" wrote:

How do I insert an Excel IV macrosheet into an Excel 2003 workbook? There was
a pull down menu that allowed the insertion of a macro sheet but that is no
longer an option. I have enabled the Excel IV language by copying a 15 year
old Excel IV application with macro sheet to an Excel 2003 workbook, and
overtyping the contents of both the spreadsheet and the macro sheet to create
a new application. Is there an easier way? I don't particularly like Visual
Basic and don't want to learn it.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default Excel IV macro sheet

1967 for me at West Point (USMA). Don't remember the model number.

--
Regards,
Tom Ogilvy

"Maxie" wrote:

Thanks Tom, I create my own spreadsheets for Federal and State Income taxes
which I update each year to reflect the changes. This year I wanted to add a
"Print" button to each form. Your reply will help immensely since I have
about 8 Federal and State forms and several other worksheets in the workbook.

M R J (Maxie)

P.S. I wrote my first computer program at Stanford Univ in 1957 on an IBM 650.

"Tom Ogilvy" wrote:

Right click on the sheet tab and choose insert. A macro sheet is an option
under that.

--
Regards,
Tom Ogilvy


"Maxie" wrote:

How do I insert an Excel IV macrosheet into an Excel 2003 workbook? There was
a pull down menu that allowed the insertion of a macro sheet but that is no
longer an option. I have enabled the Excel IV language by copying a 15 year
old Excel IV application with macro sheet to an Excel 2003 workbook, and
overtyping the contents of both the spreadsheet and the macro sheet to create
a new application. Is there an easier way? I don't particularly like Visual
Basic and don't want to learn it.

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Excel IV macro sheet

Went to a football game at USMA in October 1963 or 1964. I think the Knights
played Washington or Washington State. Stayed with an Instructor/Lt
Col?(Dr). Phillip Enslow.

Regards -- Max Jinks USAF (Ret)

"Tom Ogilvy" wrote:

1967 for me at West Point (USMA). Don't remember the model number.

--
Regards,
Tom Ogilvy

"Maxie" wrote:

Thanks Tom, I create my own spreadsheets for Federal and State Income taxes
which I update each year to reflect the changes. This year I wanted to add a
"Print" button to each form. Your reply will help immensely since I have
about 8 Federal and State forms and several other worksheets in the workbook.

M R J (Maxie)

P.S. I wrote my first computer program at Stanford Univ in 1957 on an IBM 650.

"Tom Ogilvy" wrote:

Right click on the sheet tab and choose insert. A macro sheet is an option
under that.

--
Regards,
Tom Ogilvy


"Maxie" wrote:

How do I insert an Excel IV macrosheet into an Excel 2003 workbook? There was
a pull down menu that allowed the insertion of a macro sheet but that is no
longer an option. I have enabled the Excel IV language by copying a 15 year
old Excel IV application with macro sheet to an Excel 2003 workbook, and
overtyping the contents of both the spreadsheet and the macro sheet to create
a new application. Is there an easier way? I don't particularly like Visual
Basic and don't want to learn it.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
To display contents of a folder in an excel sheet using Excel MACRO [email protected] Excel Worksheet Functions 1 June 24th 06 01:18 AM
How do I put this macro on a EXCEL sheet? roger_home Excel Discussion (Misc queries) 1 February 24th 06 01:11 AM
macro which changes the name of tab in an excel sheet vikram Excel Programming 2 May 3rd 04 05:14 PM
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet arunjoshi[_5_] Excel Programming 1 May 2nd 04 03:50 PM
Excel Macro for multiple sheet ?? somu Excel Programming 3 February 14th 04 01:07 PM


All times are GMT +1. The time now is 03:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"