xlVeryHidden
 

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.

xlVeryHidden
 

I think you will find that article referring to xl95.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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.

xlVeryHidden
 

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.
|

xlVeryHidden
 

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.
|

xlVeryHidden
 

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.
| |
|
|

xlVeryHidden
 

You're right, I am slipping into senility. My only vivid recollection is
that I had to learn VB because we had some 4.0 macrosheets that did our
inventory reports and we did not want to be caught with obsolete macros
trying to run our reports. So without any training and only the help file
for my tutorial, I proceeded to write the new program in VB. Took me about
three months, but I was successful and when I retired in 2001 they were still
using the program. They were to convert to a new system that year, but I was
still proud of that little feat. Seems to me like the help files were more
user friendly back then. Maybe it was just what our buyers negotiated in as
part of the package, like an on line text book or tutorial without
automation. I seem to remember a lot more explanation about the different
elements of VB than are included in todays help files.

"Jim Rech" wrote:

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.
| |
|
|