-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
cover up excel
- Thread starter oldham94l
- Start date
Hi Oldham94l.
I am not exactly sure what it is that you are attempting but it sounds like you want to do away with toolbars, grids, column and row headers, etc . . . If this is the case, many of these items can be hidden from view using the Tools/Options/View tab. Here you can deselect the grid, column and row headers, formula bar and so on.
Depending on how much of the Excel enviroment you wish to hide you may need some VBA in your workbook as well.
Please post back if I am on the right course with this reply and I will attempt to assist you further.
Regards,
ViperGTS
PS - 'OldHam' - radio or crowd pleaser? Just curious.
I am not exactly sure what it is that you are attempting but it sounds like you want to do away with toolbars, grids, column and row headers, etc . . . If this is the case, many of these items can be hidden from view using the Tools/Options/View tab. Here you can deselect the grid, column and row headers, formula bar and so on.
Depending on how much of the Excel enviroment you wish to hide you may need some VBA in your workbook as well.
Please post back if I am on the right course with this reply and I will attempt to assist you further.
Regards,
ViperGTS
PS - 'OldHam' - radio or crowd pleaser? Just curious.
Upvote
0
Joe Was
MrExcel MVP
- Joined
- Feb 19, 2002
- Messages
- 7,539
This is a test Form, the form has two buttons: One to Hide Excel and another to Show Excel. The form I tested this with was built with a frame, text box and the two buttons. To work this code you will need any Form with two buttons.
The code below go's into Forms "User Form1." The other code is the open activate code it go's into "ThisWorkbook's" module.
Private Sub CommandButton1_Click()
Application.Visible = True
End Sub
Private Sub CommandButton2_Click()
Application.Visible = False
End Sub
Private Sub UserForm_Click()
End Sub
Private Sub Workbook_Open()
Application.Visible = False
UserForm1.Show
End Sub
This code will show the form on open and you have the option of hiding Excel and keeping only the form up or bringing Excel back. In any case you can close the form as well. The form can be made to hold your application and to hide Excel on open so you never see Excel, only the form, floating over what-ever-else is open on your desktop. JSW
This message was edited by Joe Was on 2002-09-13 14:52
The code below go's into Forms "User Form1." The other code is the open activate code it go's into "ThisWorkbook's" module.
Private Sub CommandButton1_Click()
Application.Visible = True
End Sub
Private Sub CommandButton2_Click()
Application.Visible = False
End Sub
Private Sub UserForm_Click()
End Sub
Private Sub Workbook_Open()
Application.Visible = False
UserForm1.Show
End Sub
This code will show the form on open and you have the option of hiding Excel and keeping only the form up or bringing Excel back. In any case you can close the form as well. The form can be made to hold your application and to hide Excel on open so you never see Excel, only the form, floating over what-ever-else is open on your desktop. JSW
This message was edited by Joe Was on 2002-09-13 14:52
Upvote
0
briankelly
New Member
- Joined
- Aug 7, 2002
- Messages
- 43
Is this a Windows problem with the taskbar? Right click on the task bar, select properties and uncheck "always on top." This will give you more room for your worksheet.
Upvote
0
