| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to present a form instead of the worksheet
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to present a form instead of the worksheet
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 "Parvaiz" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to present a form instead of the worksheet
Hi Joel,
Thanx for the advice. Is it something like: Hide workbookname "Joel" wrote: 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 "Parvaiz" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| always present input form | Excel Discussion (Misc queries) | |||
| Using a Worksheet Form to add data to a separate worksheet databas | Excel Worksheet Functions | |||
| Automated task to present data in a graph form. | Charts and Charting in Excel | |||
| Automated task to present data in a graph form. | Charts and Charting in Excel | |||
| form on one worksheet and the list on different worksheet | Excel Worksheet Functions | |||
Hybrid Mode
