cover up excel

oldham94l

Board Regular
Joined
Jul 14, 2002
Messages
136
does anyone know of any programs which can be used to cover up the excel icons and program windows,
so all you see is the sheet and any vb buttons to enter values?
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Hero-0952

Wizard Deluxe
Joined
Jun 11, 2002
Messages
348
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.
 

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
 

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,011
Messages
5,569,610
Members
412,282
Latest member
bobHenk
Top