Macro Code to Add Password to Spreadsheet

[Phil_Lloyd_1979]

Hi,

I have the VBA code which runs and splits a master spreadsheet into multiple files based on a value of a given cell.

We are trying to add a password to the subsequent created files.

Is there any VBA code which can assist with this query.

Regards

Phil

[JBeaucaire]

The SaveAS command in VBA allows you to add a "Password:="MyPassword" parameter.

If you have trouble adding that or Googling examples to make the edit obvious, post your code and we'll offer something more exact.

[Phil_Lloyd_1979]

Hi,

Many thanks for your help.

I worked out the password code from another source. I am now having issues with ensuring the formulas from the master sheet are copied into the subsequent split sheets.

There is a code line which reads "ActiveSheet.Cells(2, 2).Value" which is the only reference I can see to possibly pasting the values of the master sheet.

Please can you advsie if there is any code which will ensure the formulas kept. The cell range of the sheet is A to AF.

Regards

Phil

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

New questions... new threads with appropriate titles.
Thanks.