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 he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"GreenBoy" wrote in message ups.com...
| 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)

"GreenBoy" wrote in message
ups.com...
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
=
'=
=

'================================================= ==========================
===============

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