Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,836
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spreadsheet will not open from Intranet Link Erika Excel Discussion (Misc queries) 0 August 24th 09 04:43 PM
Use UserForm to Access Spreadsheet on Corporate Intranet? ryguy7272 Excel Programming 6 June 14th 08 11:04 PM
Option to overwrite with VBA initiated open/Save Common Dialog JW[_2_] Excel Programming 1 October 12th 07 06:20 PM
Option to overwrite with VBA initiated open/Save Common Dialog Chip Pearson Excel Programming 0 October 12th 07 06:00 PM
intranet + hyperlinks problem (open in new window?) neowok[_33_] Excel Programming 0 March 1st 04 10:16 AM


All times are GMT +1. The time now is 08:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"