Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return to excel from vbe
I wrote a procedure that inserts two procedures into the activeworkbook
ThisWorbook module. I am trying to make a utility for novice users and would like them not to see the vbe (it scares them). After the code is written the vbe stays open on the ThisWorkbook module. What is the code equivalent of alt + F11? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return to excel from vbe
You can use this bobbo
Application.VBE.MainWindow.Visible = False -- Regards Ron de Bruin http://www.rondebruin.nl "bobbo" wrote in message oups.com... I wrote a procedure that inserts two procedures into the activeworkbook ThisWorbook module. I am trying to make a utility for novice users and would like them not to see the vbe (it scares them). After the code is written the vbe stays open on the ThisWorkbook module. What is the code equivalent of alt + F11? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return to excel from vbe
Thanks that works. Is there a way to keep the screen from hopping back and forth from excel to vbe while the code is executing or will I just have to live with that? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return to excel from vbe
Maybe this will help
http://www.cpearson.com/excel/vbe.htm#ScreenFlicker -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "bobbo" wrote in message ups.com... Thanks that works. Is there a way to keep the screen from hopping back and forth from excel to vbe while the code is executing or will I just have to live with that? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return to excel from vbe
When you create the code you not have to display the VBE
you can run code like this without opening the VBE See also Chip's site http://www.cpearson.com/excel/vbe.htm Sub AddProcedure() Dim VBCodeMod As CodeModule Dim LineNum As Long Set VBCodeMod = ThisWorkbook.VBProject.VBComponents("Sheet1").Code Module With VBCodeMod LineNum = .CountOfLines + 1 .InsertLines LineNum, _ "Sub MyNewProcedure()" & Chr(13) & _ " Msgbox ""Here is the new procedure"" " & Chr(13) & _ "End Sub" End With End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "bobbo" wrote in message ups.com... Thanks that works. Is there a way to keep the screen from hopping back and forth from excel to vbe while the code is executing or will I just have to live with that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return date if in range, else return blank | Excel Worksheet Functions | |||
Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
VBA Syntax for VLOOKUP to return array of return values | Excel Programming |