Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open an excel Module
Hi everyone,
I am new to Excel VBA. I have a module that works perfectly. I do the following steps to run it: Open Module Alt_F11 F5 is there a faster way to do this? Thanks Ismail -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200612/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open an excel Module
hit alt-f8
highlight the macro click options assign a shortcut key -- Gary "ielmrani via OfficeKB.com" <u21259@uwe wrote in message news:6ab427a292af6@uwe... Hi everyone, I am new to Excel VBA. I have a module that works perfectly. I do the following steps to run it: Open Module Alt_F11 F5 is there a faster way to do this? Thanks Ismail -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200612/1 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open an excel Module
tools|macro|macros (or alt-f8)
and then select the procedure you want and click Run Someday you may want to provide a "prettier" interface. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) "ielmrani via OfficeKB.com" wrote: Hi everyone, I am new to Excel VBA. I have a module that works perfectly. I do the following steps to run it: Open Module Alt_F11 F5 is there a faster way to do this? Thanks Ismail -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200612/1 -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open an excel Module
Thank you Gary. I learned something new today.
Gary Keramidas wrote: hit alt-f8 highlight the macro click options assign a shortcut key Hi everyone, I am new to Excel VBA. I have a module that works perfectly. I do the [quoted text clipped - 9 lines] Ismail -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When i open excel, i i get: Compile error in hidden Module, HELP! | Excel Discussion (Misc queries) | |||
programmatically open VBE and go to a specified procedure in target module? | Excel Programming | |||
When open an old xls, an new macro is in a new module. | Excel Programming | |||
Run module ON OPEN event?? | Excel Programming | |||
Open a XLS from a Module | Excel Programming |