Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
GJ GJ is offline
external usenet poster
 
Posts: 2
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,939
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
add an event procedure and hide the code John Smith Excel Programming 0 December 6th 06 12:49 AM
VBA Code Comments GreenBoy[_2_] Excel Programming 3 August 20th 06 10:36 AM
Event Procedure - Extending code TBD Excel Programming 2 September 29th 05 03:16 PM
Need Comments on Code Phil Hageman[_4_] Excel Programming 0 August 23rd 04 01:03 PM
Comments on this code to FTP save, please? Pat Beck Excel Programming 0 August 15th 03 06:53 PM


All times are GMT +1. The time now is 10:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"