View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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