Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform1 Border
look at Stephen Bullen's site for the FormFun.zip file. It has a workbook
that demonstrates most of the enhancements you can do to Userforms. (and the code is accessible). http://www.bmsltd.co.uk/Excel/Default.htm -- Regards, Tom Ogilvy "Neil" wrote in message ... I have a form in my sheet thats got various buttons on it to close and do other things, I want to remove the thick blue border around the form that hosts the "X" button in the top tight, is thisa possible ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform1 Border
Before you commit to removing the X, are you aware of the queryclose event
which allows you to cancel/control attempts to close the form? Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) If CloseMode = vbFormControlMenu Then Cancel = True MsgBox Prompt:="Please close the form using the close button" End If End Sub The constants you can check for CloseMode a vbFormControlMenu value: 0 The user has chosen the Close command from the Control menu on the UserForm. vbFormCode value: 1 The Unload statement is invoked from code. vbAppWindows value: 2 The current Windows operating environment session is ending. vbAppTaskManager value: 3 The Windows Task Manager is closing the application. -- Regards, Tom Ogilvy "Neil" wrote in message ... Thanks for that Tom, the page is quite interesting, I have had a look at the code for messing with userforms, I have tried copying the code to a diff sheet, and deleting unrequired code from the original, in both instances I get stuck, Im a novice so the volume of interlinked code makes this like war & piece to me.... Do you have a code snippet anywhere that just removes the border containg the "X" button from a form ? -----Original Message----- look at Stephen Bullen's site for the FormFun.zip file. It has a workbook that demonstrates most of the enhancements you can do to Userforms. (and the code is accessible). http://www.bmsltd.co.uk/Excel/Default.htm -- Regards, Tom Ogilvy "Neil" wrote in message ... I have a form in my sheet thats got various buttons on it to close and do other things, I want to remove the thick blue border around the form that hosts the "X" button in the top tight, is thisa possible ? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to filter dates using Userform1 & printing | Excel Discussion (Misc queries) | |||
border on last cell of page effects border on beginning cell of ne | Excel Discussion (Misc queries) | |||
Excel VB - show userform1 (at same time) minimized application win | Excel Discussion (Misc queries) | |||
Changing the border of one cell s/n change the border of adjacent | Excel Discussion (Misc queries) | |||
Userform1 Border | Excel Programming |