mike31z
05-02-2007, 08:55 PM
I have created a file with 5 work sheets ( I removed 2 worksheets to reduce file size) on each of the work sheet their are some cells with formula's that inter act with cells the anyone using the file can enter data and get results based on the input.
I have Uploaded my file as a zip file so I hope my macro will work. I hope.
I did not protect any sheet but, I marked the cell I don't want protected. If a sheet is protected I did not enter a password.
My Problem I can not get my macro to run when I protect the worksheet.
I have unlocked the cell under "Format, Cells, Protection" for cells E2:H121 and cellls K2:k121 on the handicap work sheet. I deleted a couple of other sheet to reduce the size of the file, there content is simular to the Handicap work sheet.
How can I get a worksheet to run a macro while the work sheet is protected in order to protect all the formulas.
mike in wisconsin
I have Uploaded my file as a zip file so I hope my macro will work. I hope.
I did not protect any sheet but, I marked the cell I don't want protected. If a sheet is protected I did not enter a password.
My Problem I can not get my macro to run when I protect the worksheet.
I have unlocked the cell under "Format, Cells, Protection" for cells E2:H121 and cellls K2:k121 on the handicap work sheet. I deleted a couple of other sheet to reduce the size of the file, there content is simular to the Handicap work sheet.
How can I get a worksheet to run a macro while the work sheet is protected in order to protect all the formulas.
mike in wisconsin