Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform on intranet: disable save button on initial launch
I have an excel userform on intranet. Once users click on the form link they
get a window with open, save and cancle buttons. I have disabled the save functionality once the excel book is open. But cannot get it to work when users initially launch the form from intranet. Is it possible to disable save button in this window? Please Help Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform on intranet: disable save button on initial launch
AFAIK, there is no 'Save' button on a UserForm, unless you put it there. If
that's the case, just delete it. The only other thing I can think of is to disable the Red 'X'. If that's what you want, look at this sample: http://www.savefile.com/files/2171226 HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "sam" wrote: I have an excel userform on intranet. Once users click on the form link they get a window with open, save and cancle buttons. I have disabled the save functionality once the excel book is open. But cannot get it to work when users initially launch the form from intranet. Is it possible to disable save button in this window? Please Help Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform on intranet: disable save button on initial launch
Hey ryan, I am not talking about any buttons on the userfrom.
The userform is on intranet and when the users click on the link to launch the userfrom(from the intranet) the file download window displays three buttons open, save and cancle. I want users to open the form everytime and not save it. "ryguy7272" wrote: AFAIK, there is no 'Save' button on a UserForm, unless you put it there. If that's the case, just delete it. The only other thing I can think of is to disable the Red 'X'. If that's what you want, look at this sample: http://www.savefile.com/files/2171226 HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "sam" wrote: I have an excel userform on intranet. Once users click on the form link they get a window with open, save and cancle buttons. I have disabled the save functionality once the excel book is open. But cannot get it to work when users initially launch the form from intranet. Is it possible to disable save button in this window? Please Help Thanks in advance |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform on intranet: disable save button on initial launch
I don't know what you have there. Maybe you could try this...
YesNo = MsgBox("A button was clicked. Is this what you want?", vbYesNo, "Warning") Select Case YesNo Case vbNo 'If answer is Yes, no additional action needs to be taken... Unload UserForm1 UserForm2.Show Case vbYes '#1 'Insert your code here if No is clicked YesNo = MsgBox("Are you absolutely sure you want to do this?", vbYesNo, "Warning") Select Case YesNo Case vbYes MsgBox "You selected €˜Yes" Cells(1, 1) = "Yes was selected!" Case vbNo '#2 YesNo = MsgBox("You answered no. Are you sure?", vbYesNo, "Warning") Select Case YesNo Case vbYes UserForm3.Show Unload UserForm2 Case vbNo '#3 MsgBox "You answered no. Please start again!!" Exit Sub End Select End Select End Select Probably the most important thing here is the Exit Sub. HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "sam" wrote: Hey ryan, I am not talking about any buttons on the userfrom. The userform is on intranet and when the users click on the link to launch the userfrom(from the intranet) the file download window displays three buttons open, save and cancle. I want users to open the form everytime and not save it. "ryguy7272" wrote: AFAIK, there is no 'Save' button on a UserForm, unless you put it there. If that's the case, just delete it. The only other thing I can think of is to disable the Red 'X'. If that's what you want, look at this sample: http://www.savefile.com/files/2171226 HTH, Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "sam" wrote: I have an excel userform on intranet. Once users click on the form link they get a window with open, save and cancle buttons. I have disabled the save functionality once the excel book is open. But cannot get it to work when users initially launch the form from intranet. Is it possible to disable save button in this window? Please Help Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform on intranet: disble save option, allow open only | Excel Programming | |||
disable save and saveas from menubar and save via command button | Excel Programming | |||
Disable save, save as, but allow save via command button | Excel Programming | |||
Macro launch - Button vs Manual launch , has different results. | Excel Programming | |||
button to launch my userform | Excel Programming |