Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi All.
I've solved my problem. Following Bob Phillips post, I selected, not "Properties" but "References" and then Selected "VBAProject". Now Excel 2007 works and I can successfully add my descriptions which I use as instant help files. Thanks. "Normek" wrote: Thank You, I have already tried both these posts. I cannot get them to work in Excel 2007 or Excel 2003 however I have found that they will work in Excel 97 of which fortunately I still have a copy. Can you get your suggestions to work in Excel 2007? "Bob Phillips" wrote: You can add a brief description(not arguments) if you open the VBEditor and ViewObject Browser. Find your UDF and right-click and you can add a comment there. This comment will be shown in the Function Wizard when you click on your UDF. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Normek" wrote in message ... 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 can't subsequently edit it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with macros in custom excel template | Excel Discussion (Misc queries) | |||
Excel 2007 custom macros/icons | Excel Discussion (Misc queries) | |||
Custom toolbar for template - macros not working | Excel Discussion (Misc queries) | |||
Custom toolbar and macros | Excel Discussion (Misc queries) | |||
Custom Menus and Macros | Excel Discussion (Misc queries) |