View Full Version : renaming a file
drawworkhome
02-06-2010, 05:18 PM
is there a way to programmatically (vba) or otherwise prevent a user from renaming a workbook?
any pointers would be appreciated.
thank you.
erik
Hi Erik,
While you can prevent (presuming macros are enabled) a SaveAs with the workbook open, I am unaware of how you would prevent the renaming of any file that is closed.
Are you doing this to prevent extra/unwanted copies from being produced?
Mark
drawworkhome
02-06-2010, 06:47 PM
hi mark, long time.
no, i am just looking for ways to prevent my code from breaking. i have my workbook creating desktop shortcuts and dont want the link to break. as an aside, it would be nice to prevent copies being made.
erik
krishhi
02-06-2010, 10:22 PM
Here is the free software to do the job.
http://www.thewindowsclub.com/prevent-cut-paste-copy-delete-re-naming-of-files-folders
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.