renaming a file

[drawworkhome]

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]

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]

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]

Here is the free software to do the job.

http://www.thewindowsclub.com/prevent-cut-paste-copy-delete-re-naming-of-files-folders