ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   put a procedure into comments with code (https://www.excelbanter.com/excel-programming/393467-put-procedure-into-comments-code.html)

GJ

put a procedure into comments with code
 
Hi,
How can I put this procedure into comments :
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call quitter_Quandclic
End Sub
like :
'Private Sub Workbook_BeforeClose(Cancel As Boolean)
' Call quitter_Quandclic
'End Sub
with code VBA

and then come back to the original

Thanks

GJ



Jim Thomlinson

put a procedure into comments with code
 
Give this a read.

http://www.cpearson.com/excel/vbe.htm
--
HTH...

Jim Thomlinson


"GJ" wrote:

Hi,
How can I put this procedure into comments :
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call quitter_Quandclic
End Sub
like :
'Private Sub Workbook_BeforeClose(Cancel As Boolean)
' Call quitter_Quandclic
'End Sub
with code VBA

and then come back to the original

Thanks

GJ





All times are GMT +1. The time now is 03:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com