Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet button question
I am using a series of buttons on a box in a worksheet to open various user
forms for my workbook database and I would like to know if there is a way to show only the box and not the Excel application in the backround when I open the file? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet button question
Application.Visible = False in the workbook open event will hide the
xl app including the worksheet with your buttons. The userform will remain visible. In the ThisWorkbook object: Private Sub Workbook_Open() Application.Visible = False UserForm.Show End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet button question
You refer to a box. Is the "Box" a toolbar or a userform?
"Mekinnik" wrote: I am using a series of buttons on a box in a worksheet to open various user forms for my workbook database and I would like to know if there is a way to show only the box and not the Excel application in the backround when I open the file? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Worksheet Button Caption on Worksheet.Activate | Excel Programming | |||
X button question | Excel Discussion (Misc queries) | |||
command button question | Excel Programming | |||
print different worksheet by pressing visible button on worksheet | Excel Worksheet Functions | |||
question about custom button | Excel Programming |