Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Prevent user deleting an XLS file


Hi there

Is there a vba code to prevent user deleting an XLS file when the file
is closed and the XL app is closed

i.e. simpley prevent deleting the file while it is closed


--
helmekki


------------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=506062

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Prevent user deleting an XLS file

Hi helmekki,

Noone else has answered so I will take a shot!

No, can only be accomplished by setting rxwd permissions.

MC

"helmekki" wrote in
message ...

Hi there

Is there a vba code to prevent user deleting an XLS file when the file
is closed and the XL app is closed

i.e. simpley prevent deleting the file while it is closed


--
helmekki


------------------------------------------------------------------------
helmekki's Profile:
http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=506062



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Prevent user deleting an XLS file


Thank u 4 reply

how to set rxwd permissions ?


--
helmekki


------------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=506062

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default Prevent user deleting an XLS file

Just give the user read-only access to the file.

Tim

"helmekki" wrote in
message ...

Thank u 4 reply

how to set rxwd permissions ?


--
helmekki


------------------------------------------------------------------------
helmekki's Profile:
http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=506062



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
How to prevent user to copy excel file to their own pc shirley_kee Excel Discussion (Misc queries) 4 April 7th 06 04:24 PM
Prevent user from overwriting file peter.thompson[_45_] Excel Programming 5 January 14th 06 12:31 PM
how do I prevent a file from opening if user has disabled macros? mwh1107 Excel Programming 2 May 26th 05 11:50 PM
Prevent User from Deleting Drawn Object Tod Excel Programming 4 July 23rd 04 09:59 AM
prevent user from saving excel file to a folder susie Excel Programming 2 July 24th 03 09:12 PM


All times are GMT +1. The time now is 03:41 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"