Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Sheets
Hi all.
So far I have a sheet and I Have a Form. I want to hide the sheet so that soon as I open my file, all I want to see if the form. Is this possible ?? Thanks all...... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Sheets
You can hide Excel so only your userform is showing.
To hide Excel when the form as activated: Private Sub UserForm_Activate() 'Hide Excel when this form is activated Application.Visible = False End Sub To show Excel again when the form is unloaded (In this example, the code is attached to a command button on the form). Private Sub cmdExit_Click() 'Close the form and show Excel. Unload Me Application.Visible = True End Sub Hope this helps, Hutch "millwalll" wrote: Hi all. So far I have a sheet and I Have a Form. I want to hide the sheet so that soon as I open my file, all I want to see if the form. Is this possible ?? Thanks all...... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Sheets
Hi! millwall. Im not pretty sure about Excel been able to hide all sheets, but here's a workaround if you dont mind displaying only one formated sheet. 1. In the Forms bar, click the Toogle Grid button so you wont the cells border's, after that, select all the cells and fill them with some background color you like. You can even rename the worksheet tab to " " (single space) so it say nothing. 2. Open the Visual Basic Editor, you'll see a window called project and a file called "ThisWorkbook", double clic on it, it will automatically open the code editor, in the Object combo box, select Workbook, then in the procedure combo box select the "Open" event. Excel automatically pastes some code like this: ---------------------------------------------------------------------------------- Private Sub Workbook_Open() End Sub ---------------------------------------------------------------------------------- 3. Paste inside the sub this code: ---------------------------------------------------------------------------------- Sheet1.Visible = xlSheetHidden UserForm1.Show ---------------------------------------------------------------------------------- 4. It suposes you have two sheets, sheet1 is the one you want to hide, and the other its the one you format. Hope it works for you. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Sheets
I have tried this but dont seem to be working what I have is in micrsoft
visual basic I have form called Software_form then I have a spreadsheet called data I want to if possible total hide the data speadsheet so when the user double clcik the excel file all they see if the Software_form. I dont want the user to see the spreadsheet form at all that only goona be for my viewing and updating they dont need to know about it... "Lt. Bonifacius" wrote: Hi! millwall. Im not pretty sure about Excel been able to hide all sheets, but here's a workaround if you dont mind displaying only one formated sheet. 1. In the Forms bar, click the Toogle Grid button so you wont the cells border's, after that, select all the cells and fill them with some background color you like. You can even rename the worksheet tab to " " (single space) so it say nothing. 2. Open the Visual Basic Editor, you'll see a window called project and a file called "ThisWorkbook", double clic on it, it will automatically open the code editor, in the Object combo box, select Workbook, then in the procedure combo box select the "Open" event. Excel automatically pastes some code like this: ---------------------------------------------------------------------------------- Private Sub Workbook_Open() End Sub ---------------------------------------------------------------------------------- 3. Paste inside the sub this code: ---------------------------------------------------------------------------------- Sheet1.Visible = xlSheetHidden UserForm1.Show ---------------------------------------------------------------------------------- 4. It suposes you have two sheets, sheet1 is the one you want to hide, and the other its the one you format. Hope it works for you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding zero values on all sheets & by default on new sheets | Excel Worksheet Functions | |||
Hiding sheets | Excel Discussion (Misc queries) | |||
Locking Sheets / Hiding Sheets | Excel Worksheet Functions | |||
hiding sheets | Excel Programming | |||
Hiding Sheets | Setting up and Configuration of Excel |