LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Excel will not open

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ON OPEN VBA Code input incorrectly now excel sheet wont open mmartin New Users to Excel 1 February 16th 11 11:33 PM
excel 2003 saved file will not open without a blank workbook open Bob Excel Discussion (Misc queries) 4 November 11th 06 04:24 PM
EXCEL wont open from Explorer, must open EXCEL then find file wludwick Excel Discussion (Misc queries) 4 September 7th 06 08:06 PM
workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. san Excel Programming 1 January 3rd 06 03:22 AM
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 Frank Jones Excel Programming 2 June 15th 04 03:21 AM


All times are GMT +1. The time now is 07:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"