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