but my memory tells me

You don't rely on that do you?<g

Fwiw, I have Excel 95 still installed and there is no VBE.

I think that year was optional to use the module sheet with Macro 4.0 or
the VBE with VB, later to be called VBA

The only "module sheet" was for VB. Excel 4 macros had "Excel 4 macro
sheets".

Microsoft warned that they would quit supporting Macro 4.0 with their next
version

Well, what MS said was they were no longer going to enhance the Excel 4
macro language but they have continued to support it as is up through Excel
2007. I'll be interested to hear if that's still true in Excel 2009 or
whatever they call the next version.

Maybe another old hand can adjudicate our remembrances<g.


--
Jim
"JLGWhiz" wrote in message
...
| Hi Jim, I agree with the dialog sheets in your history lesson, but my
memory
| tells me that with the advent of VB as the recommended macro code in Excel
5,
| there was a VB editor. I think that year was optional to use the module
| sheet with Macro 4.0 or the VBE with VB, later to be called VBA.
Microsoft
| warned that they would quit supporting Macro 4.0 with their next version
of
| Excel and that was when I decided to learn VB. But we could be playing
| semantics here because I don't remember if the technical name for the code
| pane was called VBE at the time. There might have been another name for
it,
| but it essentially did what the VBE does today.
|
| "Jim Rech" wrote:
|
| Further to Don, and FYI, the first two versions of Excel that supported
VBA
| were Excel 5 and Excel 95. In both there was no separate Visual Basic
| Editor. Code was entered in a 'module sheet' which was inserted into a
| workbook just the way you'd insert a worksheet. There were no userforms
| either. Instead there were 'dialog sheets'.
|
| --
| Jim
| "Mike H." wrote in message
| ...
| |I just read this article:
| |
| | http://support.microsoft.com/kb/153587
| |
| | and do not understand it at all. It uses the term "module sheet" and
I
| | don't understand what that is referring to. I don't understand the
| problem
| | and don't see how you could ever have a sheet hidden that you couldn't
| simply
| | have code somewhere that turned visible= true. Can somebody explain
this
| to
| | me. Thanks a lot.
| |
|
|