Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm not sure what I've done or how to fix it. But, I added the
following to a macro: Application.Visible = False UserForm1.Show Application.Visible = True I was attempting to hide the worksheets behind the form, it seemed to work OK until I clicked on a button that was to copy values from various comboboxes and textboxes to a sheet and perform a print preview. (which worked perfectly until I added the above code.) Once I hit the button, excel shut down on me and now the workbook will not open, as if the 'application.visible = false' is still running. If I open Microsoft Excel, a blank sheet, then open my workbook, it will open. But, when I go to the code, it's not there? Can anyone clue me in on what I did? And is there a way to fix it? Also, I copied this now open file and saved it to another name, but still won't open when it's doubled clicked... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ON OPEN VBA Code input incorrectly now excel sheet wont open | New Users to Excel | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
EXCEL wont open from Explorer, must open EXCEL then find file | Excel Discussion (Misc queries) | |||
workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming |