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.


--
mag7417
------------------------------------------------------------------------
mag7417's Profile: http://www.excelforum.com/member.php...o&userid=28413
View this thread: http://www.excelforum.com/showthread...hreadid=480088