D
des-sa
please could someone help.
i have a macro which uses certain cell entries in a sheet in my workbook to
save the excel file as "psmith-chevrolet-quotenr1234-150109" for easy
identification afterwards. is it possible to add vb script that would lock
the file for editing after it has been saved the first time? the file is a
quote which is given to customers, and i want to prohibit employees from
altering another employee's quote afterwards. futhermore, is it possible to
incorporate password protection for editing?
thanks
i have a macro which uses certain cell entries in a sheet in my workbook to
save the excel file as "psmith-chevrolet-quotenr1234-150109" for easy
identification afterwards. is it possible to add vb script that would lock
the file for editing after it has been saved the first time? the file is a
quote which is given to customers, and i want to prohibit employees from
altering another employee's quote afterwards. futhermore, is it possible to
incorporate password protection for editing?
thanks