Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba proj
Hi All,
I have excel based tracker. All the macro part working fine. Problem is I sent the file to all the users. Small mistake I made in Macro part ie., instead of Uform.optionbutton1 = true I put that one as Uform.optionbuttion2 = true. I need to change only one line code in the module. I am learning how to change the module codes using macro. pls. let me know how to do this ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba proj
On Dec 16, 7:49*am, "fi.or.jp.de" wrote:
Hi All, I have excel based tracker. All the macro part working fine. Problem is I sent the file to all the users. Small mistake I made in Macro part ie., instead of Uform.optionbutton1 = true I put that one as * * * * * * * *Uform.optionbuttion2 = true. I need to change only one line code in the module. I am learning how to change the module codes using macro. pls. let me know how to do this ? Tools-Macro- Select your macro from list of macro names -Edit |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba proj
Press Alt + F11
ViewProject Explorer Then Click the module your code is in. Make you changes Click Save -- Cheers, Ryan "fi.or.jp.de" wrote: Hi All, I have excel based tracker. All the macro part working fine. Problem is I sent the file to all the users. Small mistake I made in Macro part ie., instead of Uform.optionbutton1 = true I put that one as Uform.optionbuttion2 = true. I need to change only one line code in the module. I am learning how to change the module codes using macro. pls. let me know how to do this ? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
template 4 proj cost analysis (sales value - expenses=profit) | Excel Programming |