How to present a form instead of the worksheet

P

Parvaiz

Hi, I have created one Excel Spreadsheet which has some VBA modules and
procedures etc.
1: I would like the user to ONLY see the Form and to "hide" the actual
worksheet from view.

2: Options and Controls on the Form run VBA in the background. I have
already created the form, but how do I minimize it out of the way so that the
user can carry on with other things on his/her pc? At the moment it just has
an X button in the top right hand corner.

By the way, I am creating all this in Excell 2007 (in compatability mode for
2003)Any advise would be much appreciated.
 
J

Joel

1) You can hidfe all the worksheets and use the workbook open event to
perform the Userform1.Show command.

2) see VBA help for
ShowModal Property
 

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

How to use multiple command button to copy user form data to multiple worksheet 0
How to insert new worksheet based on # of rows in a data sourch 2
Tabbing through input worksheet 2
E-mailing a worksheet 1
Export as pdf form to ipad 2
Worksheet form vs. Userform...which is better? 5
show worksheet along with form 5
how to hide a form button in a worksheet 1

Top