View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Description in custom macros

Hi,

I'm not entirely sure I understand but if you add a description to your
macro prior to recording then it appears as commented text at the start of
the macro. It can be edited anytime by opening VB editor (Alt +F11) anf
navigating to the macro.

You can add new lines of text by preceding that line with a ' or the keyword
Rem and those comments can be anywhere in the code.

Mike

"Normek" wrote:

Description text in Macros
Windows help files show you how to add a description in custom Macros.
I have tried to follow this but with only one success, and I haven't been
able to reproduce it or edit the description.

There appears to be a step missing. Has anyone tried to add a description to
their macros or functions or edit the descriptions and succeeded?

I know that you can add the description when you are recording the macro,
successfully but I cant subsequently edit it.