why? - Ctrl+ F11 and sheet names

[JulieD]

Why when i use ctrl + F11 to insert a worksheet does it call the worksheet
"Macro 1", "Macro 2" etc instead of Sheet x ... ?

just wondering

Regards
JulieD

 

[Debra Dalgleish]

Shift + F11 inserts a worksheet
Ctrl + F11 inserts an Excel 4.0 macro sheet

 

[JE McGimpsey]

You're inserting an XL4M Macro sheet.

 

[JulieD]

Hi guys

thanks - so it's SHIFT + F11 i was after then ... BTW what is a "macro
sheet" (wasn't using excel back in ver 4).

Cheers
JulieD

 

[Debra Dalgleish]

Before Visual Basic for Applications, macro instructions were written on
a macro sheet, that looked like a worksheet. There's a sample macro here:

Starting Excel with No Worksheets Open
http://support.microsoft.com/default.aspx?id=77538

 

[JulieD]

Hi Debra

oh, i see ... interesting way to program (i think i like VBA better!).

Thanks
JulieD