ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform on intranet: disble save option, allow open only (https://www.excelbanter.com/excel-programming/431953-userform-intranet-disble-save-option-allow-open-only.html)

Sam

Userform on intranet: disble save option, allow open only
 
Hi All,

I have designed a userform that is to be posted on companys intranet, Rite
now when people launch the userform it asks them if they want to save it or
directly open it. Is there a way where they can only open it and dont have an
option to save the form?

Thanks in advance

ryguy7272

Userform on intranet: disble save option, allow open only
 
Hummm...I've never encountered this particular scenario, but check one of the
solutions he
http://www.ozgrid.com/VBA/prevent-save-prompt.htm

Several of those code snippets seem reasonable.


HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"sam" wrote:

Hi All,

I have designed a userform that is to be posted on companys intranet, Rite
now when people launch the userform it asks them if they want to save it or
directly open it. Is there a way where they can only open it and dont have an
option to save the form?

Thanks in advance



All times are GMT +1. The time now is 10:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com