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?
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

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.
 

Forum statistics

Threads
1,148,269
Messages
5,745,782
Members
423,972
Latest member
franklins

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top