Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Workbook Hidden Problem
I have a workbook with 16 forms and 5 sheets. Somehow, during my coding, the
actual BOOK has disappeared. I can see that the 5 sheets exist under VB, but have no way to access them. Unfortunately, these sheets are critical. I have attempted to use the .VISIBLE methods and activate, but nothing appears. Inside of the Excel window, no commands are avaiable except to exit the program, or create a new book. In the Excel window, nothing is minimized on the bottom like should appear when the book is minimized and Excel is left open. Please, Please Help. I am an Instructor at a college, and this is the exam. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Workbook Hidden Problem
"GIScoobe" wrote in message ... I have a workbook with 16 forms and 5 sheets. Somehow, during my coding, the actual BOOK has disappeared. I can see that the 5 sheets exist under VB, but have no way to access them. Unfortunately, these sheets are critical. I have attempted to use the .VISIBLE methods and activate, but nothing appears. Inside of the Excel window, no commands are avaiable except to exit the program, or create a new book. In the Excel window, nothing is minimized on the bottom like should appear when the book is minimized and Excel is left open. Please, Please Help. I am an Instructor at a college, and this is the exam. Maybe this will help. Actually, I'm not sure what your problem is. My guess is that your file has been damaged. http://office.microsoft.com/en-us/as...346561033.aspx http://www.ultimaterepository.com/Ut...ies/10267.aspx http://www.softaward.com/2867.html /Fredrik |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Workbook Hidden Problem
I can think of two possibilities:
1) The "Window" of your current workbook is hidden; or 2) You have set the "IsAddIn" properties of the workbook as TRUE. If (1), In Excel, from the Windows menu, choose Unhide. There you can unhide any hidden windows. If (2), In VBA Editor, press Ctrl+g to show the "Immediate Window". In the Immediate Window, type the following statement and press return to execute workbooks("you_file_name").IsAddin=False In the statement, replace "you_file_name" by the file name, including extension. For example, myfile.xls. Regards, Edwin Tam http://www.vonixx.com "GIScoobe" wrote: I have a workbook with 16 forms and 5 sheets. Somehow, during my coding, the actual BOOK has disappeared. I can see that the 5 sheets exist under VB, but have no way to access them. Unfortunately, these sheets are critical. I have attempted to use the .VISIBLE methods and activate, but nothing appears. Inside of the Excel window, no commands are avaiable except to exit the program, or create a new book. In the Excel window, nothing is minimized on the bottom like should appear when the book is minimized and Excel is left open. Please, Please Help. I am an Instructor at a college, and this is the exam. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Macro cannot see hidden workbook | Excel Discussion (Misc queries) | |||
can't move my workbook, top bar hidden | Excel Discussion (Misc queries) | |||
Tabs in my workbook are hidden | Excel Discussion (Misc queries) | |||
Excel. I am having a problem with hidden text | Excel Discussion (Misc queries) | |||
How to hide a workbook and to detect a hidden workbook in visual basic | Excel Programming |