Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Okay so i have a inputbox that pops up from this code.
Dim Message2, Title2, MyValue Message = "Please Enter Last 5 Digits of Your Card Number" Title = "AMEX Number" '<--Change MyValue = InputBox(Message, Title) If MyValue = "" Then Sheets("Expense Amex").Protect password:="welcome" Exit Sub End If Range("Cardholder_Number").AutoFilter Range("Cardholder_Number").AutoFilter Field:=1, Criteria1:=MyValue, visibleDropDown:=False Sheets("Expense Amex").Protect password:="welcome" On Error Resume Next What i want to do is make it so they cant press the red X in the top right of the form. how do i do this? Thanks, Alex |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
disable objects on form | Excel Programming | |||
disable saving excel form | Excel Programming | |||
disable form movement | Excel Programming | |||
I need to disable to X on a user form | Excel Discussion (Misc queries) | |||
Disable Label in a Form | Excel Programming |