PDA

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

GTO
02-06-2010, 06:42 PM
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