VBA Code Comments

  • Thread starter Thread starter GreenBoy
  • Start date Start date
G

GreenBoy

Hi

Years ago I downloaded a wonderfull utility from Rob Bruce (I think)
that allowed you to insert a block of comments into Excel VBA at either
the Module or Procuedure, function and property level, including some
of your own notes etc..

The inserted comments looked something like this (excelpt the end '='
were aligned!!)

Any one know if this is still available for download as I have lost my
copy?

Many thanks
GreenBoy

'==========================================================================================
'=
=
'= Module: D_Code
=
'= Type: Standard Module
=
'=
=
'= Developer: GreenBoy
=
'= Date: 15-Feb-2004
=
'=
=
'= Description: D_Code - This module contains all the code created
by GreenBoy =
'= for Delever to cope with the unlocking of the
workbook on its first =
'= use after the user supplies the correct code.
=
'=
=
'= Subprocedures: MatchCodes
=
'= UnlockMe
=
'= SetUp
=
'= UnhideSheets
=
'= ShowLockSheet
=
'= Functions: None
=
'= Properties: None
=
'= DLL Declares: None
=
'=
=
'==========================================================================================
 
Look here:

http://www.appspro.com/Utilities/Utilities.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi
|
| Years ago I downloaded a wonderfull utility from Rob Bruce (I think)
| that allowed you to insert a block of comments into Excel VBA at either
| the Module or Procuedure, function and property level, including some
| of your own notes etc..
|
| The inserted comments looked something like this (excelpt the end '='
| were aligned!!)
|
| Any one know if this is still available for download as I have lost my
| copy?
|
| Many thanks
| GreenBoy
|
| '==========================================================================================
| '=
| =
| '= Module: D_Code
| =
| '= Type: Standard Module
| =
| '=
| =
| '= Developer: GreenBoy
| =
| '= Date: 15-Feb-2004
| =
| '=
| =
| '= Description: D_Code - This module contains all the code created
| by GreenBoy =
| '= for Delever to cope with the unlocking of the
| workbook on its first =
| '= use after the user supplies the correct code.
| =
| '=
| =
| '= Subprocedures: MatchCodes
| =
| '= UnlockMe
| =
| '= SetUp
| =
| '= UnhideSheets
| =
| '= ShowLockSheet
| =
| '= Functions: None
| =
| '= Properties: None
| =
| '= DLL Declares: None
| =
| '=
| =
| '==========================================================================================
|
 
Get a copy of the free MZ-Tools for VBA, www.mztools.com, indispensable!

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Just to let people know this was not an AppsPro application (Rob
Bovey), but by a nother guy called Rob Bruce who produced an add in
called ModTools.

Unfortunately Robs web page seems to have disapeared from the web.

All the Best
SpamDelux
 
Back
Top