Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All
I found a link on this forum and downloaded the code to eliminate the x close button on my user forms. It worked great until someone opened my workbook in 2002. (I have 2000). They still had the x in the title bar of the form. Any one know how to fix that or where I can find an update. I forgot where I got the the original. Thanks Christy |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
As Robin replies below:
Select Case Int(Val(Application.Version)) Case 8 'Excel 97 hWnd = FindWindow("ThunderXFrame", _ oDialog.Caption) Case Else 'Excel 2000, 2002, 2003? hWnd = FindWindow("ThunderDFrame", _ oDialog.Caption) End Select -- Regards, Tom Ogilvy Christy wrote in message ... Hi All I found a link on this forum and downloaded the code to eliminate the x close button on my user forms. It worked great until someone opened my workbook in 2002. (I have 2000). They still had the x in the title bar of the form. Any one know how to fix that or where I can find an update. I forgot where I got the the original. Thanks Christy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why excel close all files when I just want to close one files | Excel Discussion (Misc queries) | |||
why do all excel worksheets/workbooks close when I close one? | Excel Discussion (Misc queries) | |||
close button does not close | Excel Discussion (Misc queries) | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel |