Inserting rows in protected sheet

[rajeshkumar]

This problem may sounds funny.
I have two columns say Col. E and F which are protected and contains formulas.
When I try to insert a row, its is throwing error. I want to insert a row and also the formulae in the columns in E and F has to be reflected in the inserted row.
In the meantime the cells in the Col. E and F has to be protected.

Is there any way for doing this?

Thanks in advance.

Rajesh

[Rich_z]

All worksheets should be protected from the prying fingers of end users, but this causes a problem when you want to programatically make changes.

What I do is I have two subroutines Lock_Sheet and Unlock_Sheet:

Please Login or Register  to view this content.

The actual statement that does the work is

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

However, there are a lot of other things to consider as well such as:

• Process events
• Process Calculations
• Display changes as they happen or not
• Display alerts that might be triggered or not

That's why there is a hell of a lot more code surrounding the relevant statements above.

I tend to use a push down stack to store everything that I need to keep track of such as the current state of the worksheet, messages being displayed to the user etc. In that way I can call these routines as many times as I like as long as the calls happen in pairs.

An example of how to do this is below:

Please Login or Register  to view this content.

Regards

Rich