| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding the Excel UI when running a userform
I have a user form that is used to capture data that updates another
spreadsheet. Is it possible to programmatically hide all of the Excel user interface so that the end user only sees the user form? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding the Excel UI when running a userform
This gets rid of quite a bit. You can play with it to see if it is what you
are looking for. With Application .DisplayFullScreen = True .DisplayFormulaBar = False .DisplayStatusBar = False End With With ActiveWindow .DisplayHorizontalScrollBar = False 'Make space and clear screen .DisplayVerticalScrollBar = False .DisplayWorkbookTabs = False .DisplayHeadings = False .DisplayGridlines = False End With "Ken Warthen" wrote: I have a user form that is used to capture data that updates another spreadsheet. Is it possible to programmatically hide all of the Excel user interface so that the end user only sees the user form? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding the Excel UI when running a userform
You can use Application.Visible = False. Make sure that it gets set back to
True even when (especially when) an error occurs. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Ken Warthen" wrote in message ... I have a user form that is used to capture data that updates another spreadsheet. Is it possible to programmatically hide all of the Excel user interface so that the end user only sees the user form? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding the Excel UI when running a userform
Thanks Chip. Is there the equivalent of an autoexec routing in which I could
place the code? It would be cool if I could just have the form appear without the user ever seeing the Excel UI. Ken "Chip Pearson" wrote: You can use Application.Visible = False. Make sure that it gets set back to True even when (especially when) an error occurs. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Ken Warthen" wrote in message ... I have a user form that is used to capture data that updates another spreadsheet. Is it possible to programmatically hide all of the Excel user interface so that the end user only sees the user form? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding the Excel UI when running a userform
You can put the code in the Workbook_Open event procedure in the
ThisWorkbook code module or in a macro named Auto_Open. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Ken Warthen" wrote in message ... Thanks Chip. Is there the equivalent of an autoexec routing in which I could place the code? It would be cool if I could just have the form appear without the user ever seeing the Excel UI. Ken "Chip Pearson" wrote: You can use Application.Visible = False. Make sure that it gets set back to True even when (especially when) an error occurs. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Ken Warthen" wrote in message ... I have a user form that is used to capture data that updates another spreadsheet. Is it possible to programmatically hide all of the Excel user interface so that the end user only sees the user form? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding the Excel UI when running a userform
Or put it into the code that calls the userform.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Chip Pearson" wrote in message ... You can put the code in the Workbook_Open event procedure in the ThisWorkbook code module or in a macro named Auto_Open. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Ken Warthen" wrote in message ... Thanks Chip. Is there the equivalent of an autoexec routing in which I could place the code? It would be cool if I could just have the form appear without the user ever seeing the Excel UI. Ken "Chip Pearson" wrote: You can use Application.Visible = False. Make sure that it gets set back to True even when (especially when) an error occurs. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Ken Warthen" wrote in message ... I have a user form that is used to capture data that updates another spreadsheet. Is it possible to programmatically hide all of the Excel user interface so that the end user only sees the user form? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding the Excel UI when running a userform
That's exactly what I was looking for thanks. I haven't done much VBA
programming in the last five years or so, but am getting back into it with an assortment of projects at work. Any recommendations for books related to VBA programming in Excel 2007? TIA "Chip Pearson" wrote: You can put the code in the Workbook_Open event procedure in the ThisWorkbook code module or in a macro named Auto_Open. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Ken Warthen" wrote in message ... Thanks Chip. Is there the equivalent of an autoexec routing in which I could place the code? It would be cool if I could just have the form appear without the user ever seeing the Excel UI. Ken "Chip Pearson" wrote: You can use Application.Visible = False. Make sure that it gets set back to True even when (especially when) an error occurs. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Ken Warthen" wrote in message ... I have a user form that is used to capture data that updates another spreadsheet. Is it possible to programmatically hide all of the Excel user interface so that the end user only sees the user form? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding the Excel UI when running a userform
Here are the books I like:
http://peltiertech.com/Excel/xlbooks.html#ExcelVBA Anything by Walkenbach is a good start: solid and easy to follow. The books by Bullen, Bovey, et al, are more advanced. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ken Warthen" wrote in message ... That's exactly what I was looking for thanks. I haven't done much VBA programming in the last five years or so, but am getting back into it with an assortment of projects at work. Any recommendations for books related to VBA programming in Excel 2007? TIA "Chip Pearson" wrote: You can put the code in the Workbook_Open event procedure in the ThisWorkbook code module or in a macro named Auto_Open. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Ken Warthen" wrote in message ... Thanks Chip. Is there the equivalent of an autoexec routing in which I could place the code? It would be cool if I could just have the form appear without the user ever seeing the Excel UI. Ken "Chip Pearson" wrote: You can use Application.Visible = False. Make sure that it gets set back to True even when (especially when) an error occurs. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Ken Warthen" wrote in message ... I have a user form that is used to capture data that updates another spreadsheet. Is it possible to programmatically hide all of the Excel user interface so that the end user only sees the user form? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to keep UserForm open at all times while excel is running | Excel Discussion (Misc queries) | |||
| Running a Userform from Excel | Excel Programming | |||
| Running a Userform from Excel | Excel Programming | |||
| Running a UserForm (seemingly) Independent of Excel...? | Excel Programming | |||
| Hiding Columns running slow | Excel Programming | |||
![Ken Warthen[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
