LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Prevent user from overwriting file


I want to prevent a user from ever overwriting a certain file:
"C:\Business Cases\Master Template.xls" i.e. I want to preserve the
integrity of the template.

I also want the user to always save files in the "C:\Business Cases"
folder, which is automatically created the first time the workbook is
opened

Would appreciate any help on the best way of going about this - it's
been a very long day!

Cheers

Peter (...slogging it through VBA)


--
peter.thompson
------------------------------------------------------------------------
peter.thompson's Profile: http://www.excelforum.com/member.php...o&userid=29686
View this thread: http://www.excelforum.com/showthread...hreadid=501322

 
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
prevent cell overwriting connect4u Excel Worksheet Functions 1 December 22nd 09 01:28 PM
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
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 saving file to a folder but allow my code to save from behind. susie Excel Programming 3 July 25th 03 03:01 PM
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 09:30 AM.

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

About Us

"It's about Microsoft Excel"