running Macro on a Protected Worksheet

Hi there,

I am attempting to run a macro on a worksheet that is protected. Unfortunately, I do not want the worksheet unprotected to run the macro, since the user has a tendancy to change formulas. How can I get around this?

Martha

Thanks for updating your title.

take a look at the link under

UserInterFaceOnly

http://www.ozgrid.com/VBA/excel-macr...cted-sheet.htm

VBA Noob

Example workbook here

http://www.excel-it.com/vba_examples.htm