Locking single sheet in workbook

[scottimus]

is there a way to lock formats and formulas in a single sheet in a workbook? basically, i have created a workbook for our work traffic coordinator that she updates every week by making a new sheet and fills in that weeks worth of workflow. i made a "master" sheet in the book that she copies into the new weekly sheet and then fills in with jobs and workflow into the correct sections. the master contains formats and formulas that reflect employee's hourly workflow, due dates, etc. the problem is, the workbook is on a public server at work and i dont want the master to be changed at all, but the weekly sheets can be altered if necessary. i just want to lock the master sheet so that when she copies it to a new weekly sheet, its always the same. any suggestions?? i know this sounds confusing, so if you have questions, please ask... thanks

[Dunc3142]

Save the workbook as a template. When a template is opened it opens as a new workbook and leaves your template untouched.

Do a Save As when the save as dialog box is there change the file of type at the bottom of the box to Template.

[solnajeff]

Hi

Attached is a small file with three macros that allow users to create a new sheet, also for you to view and hide the master page using a password (currently 123). The workbook is then protected and no pages may added or removed.

To prevent anyone from changing the code you will need to set a VBA project password. Click Alt F11 to view the VBA code and right click on the file name in the project window then in VBA project properties click the protection tab and enter a password.

Regards

Jeff

[scottimus]

thanks for the macros! they work great!