Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.Visible Property
Thanks Dan
Changing this gives me RTE 9 "Sub-script out or range". Thinking about it, I really need to hide Excel & only disply the form. What is the easiest way of doing this? Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
.Visible Property
Jollynicechap,
You could try this, but be careful with it as an error in the wrong place might cause havoc. Private Sub Workbook_Open() Application.Visible = False UserForm1.Show End Sub You'll need to include an Application.Visible = True somewhere to get Excel back into view. John Jollynicechap wrote: Thanks Dan Changing this gives me RTE 9 "Sub-script out or range". Thinking about it, I really need to hide Excel & only disply the form. What is the easiest way of doing this? Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Use DateLastModified Property in VBA? | Excel Discussion (Misc queries) | |||
Windows Visible Property - Code Help | Excel Discussion (Misc queries) | |||
Property Management | Excel Discussion (Misc queries) | |||
How to get Signature property! | Excel Discussion (Misc queries) | |||
Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) |