Worksheet button question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Specific Worksheet Using Button Form Control in Excel 0
Deselect a worksheet? 3
How to use multiple command button to copy user form data to multiple worksheet 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel crashes and restarts when accessing newly created worksheet 2
Userform Save data To Worksheet & File 1
Referencing command button on worksheet from VBA 3
Protect each worksheet individually 4

Back
Top