Dave Peterson laid this down on his screen :
Activeworkbook.ChangeFileAccess Mode:=xlReadOnly
kill activeworkbook.fullname



On 02/11/2011 22:35, Hello wrote:
I also need to delete the file (have / include file name "test") if
the file is open too (active workbook). And don't want to shown the
pop up message on the screen.

Thanks, Dave! I didn't think this was possible but I see I was wrong.
This adds a whole new dynamic to file management...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc