userform on intranet: disable save button on initial launch

[sam]

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

 

[ryguy7272]

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--

 

[sam]

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]

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---