Unlocking Macro in protected sheet

[mag7417]

A simple question:

- I have a rather large sheet with a lot of data in it.
- In order to simplify sorting I recorded a few macros.
- Since it is for government use I know a lot of people will be using it who don't know how not to change data that shouldn't be changed, I have protected the sheet.
- Before locking the sheet I changed the properties of the cells that they should be able to change, unchecking the lock box.
- When running the simple sorting macro VB tells me that I need to unlock the sheet even though the cells containing the macros are unlocked.

Anyone got a tip on how I can get around this? I.e. I need to have the sheet protected while at the same time I want the macros activated.

[Sprout]

Your macro may be trying to update cells in your worksheet. It will not be able to do this if these cells are locked. e.g. If your macro carrys out a goal seek, changing one cell to match another, it will only do this if the cell it needs to change is not protected. i.e. it can write to this cell. Therefore what you need to do is unlock any cells which your macro needs to write to.
Hope this helps.

[hwolf60]

Start your macro with
ActiveSheet.Unprotect

and end it with
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

Good luck