How to present a form instead of the worksheet

  • Thread starter Thread starter Parvaiz
  • Start date Start date
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.
 
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
Excel VBA - Problem with Closing Print Preview 0
'Cannot insert object' message when I try to put a button on a worksheet 7
Tabbing through input worksheet 2
Open Specific Worksheet Using Button Form Control in Excel 0
Export as pdf form to ipad 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top