Send form after replacing formulas by values

I start with a file called "A.xlsm"

This file is an excel form, used as an request sheet. Some user data are retrieved automatically based upon the user ("Value = Environ("Username")". The macro I am writing, saves the file as "B.xlsm" before putting it in an outlook message that goes to a colleague.

When that colleague opens the file, his own user data overwrite the original user data, for obvious reasons.

I therefore want to freeze some (NOT ALL !) cells in the B-file, letting the A-file unchanged.

How ?

Hi jokkebal,

Try the following steps (Macro Recorder should help you develop VBA code):
a. In File A.xlsm, savecopyas B.xlsm.
b. Open B.xlsm
c. Select a sheet
d. Unprotect the Sheet
e. Unlock all cells in the Sheet (Home > Select all cells > Format > Format Cells > Protection > Uncheck Locked > OK
f. Select and lock cells as required
g. Protect the Sheet
h. Save the file

I hope this helps.

If you need additional help, please upload a sample workbook indicating what sheet and what cells you want to protect.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Lewis