Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lost view of Application
I am trying to set up a workbook so that only the userform is visible when
the workbook is open. I went into the code and in workbook I entered the following: Application visible= false Userform.show When I clicked on the workbook to open it the userform came up like I was wanting but now I can't get back into the application. Is there anyway now to get back into the workbook to make changes? If not can someone tell me how I can set the workbook so when it is opened no one can make any changes or unhide the worksheets. In other words is it possible to at least hide the ribbon/toolbars. Thanks in advance -- BillD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lost view of Application
You could try adding code to one of the UserForm events, maybe Unload:
Private Sub UserForm_Deactivate() Application.Visible = True End Sub "BillD" wrote in message ... I am trying to set up a workbook so that only the userform is visible when the workbook is open. I went into the code and in workbook I entered the following: Application visible= false Userform.show When I clicked on the workbook to open it the userform came up like I was wanting but now I can't get back into the application. Is there anyway now to get back into the workbook to make changes? If not can someone tell me how I can set the workbook so when it is opened no one can make any changes or unhide the worksheets. In other words is it possible to at least hide the ribbon/toolbars. Thanks in advance -- BillD |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lost view of Application
Have you tried holding down the SHIFT key, when opening your worksheet to
prevent your code from running? If that does not work you can password protect your workbook - as far as I remember this means that people can only unhide sheets if they know the password to unprotect the workbook. Regards, anlu "BillD" wrote: I am trying to set up a workbook so that only the userform is visible when the workbook is open. I went into the code and in workbook I entered the following: Application visible= false Userform.show When I clicked on the workbook to open it the userform came up like I was wanting but now I can't get back into the application. Is there anyway now to get back into the workbook to make changes? If not can someone tell me how I can set the workbook so when it is opened no one can make any changes or unhide the worksheets. In other words is it possible to at least hide the ribbon/toolbars. Thanks in advance -- BillD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost tool bar & view | Excel Discussion (Misc queries) | |||
Lost Commands on Toolbar ie. File, View, etc. | Excel Discussion (Misc queries) | |||
Lost view of spreadsheet EXCEL 2007 | Excel Discussion (Misc queries) | |||
Help! Lost sheets by using View Code on worksheet tab | Excel Discussion (Misc queries) | |||
I lost the cell view just below my toolbar. | Excel Discussion (Misc queries) |