allow macro to get behind cell protection

[Billm]

My spreadsheet uses Protect Sheet and Protect Workbook. I have protected the range A1.. A3 in my spreadsheet to stop users from messing things up. Instead they have a macro which they can run which will change the formulas in those cells. But as those cells are protected .. the macro errors out when run.

Is there VB code I can put into the start of the macro that will un-protect those cells, then as it finishes .. puts the protection back on.

Thanks Bill

 

[shades]

For protecting you could use:

ActiveWorkbook.Protect Structure:=True, Windows:=True

I may be too old for this!!! And I'm too tired to go further!

_________________
- old, slow, and confused
... but at least I'm inconsistent -
This message was edited by shades on 2002-04-24 07:10

 

[Billm]

Thanks .. works great
Bill