locking worksheet deletes cell formulas

[JanezP]

Helo!

I created a macro to insert and delete lines in a worksheet. The code I used for insert is as follows:

Please Login or Register  to view this content.

This worksheet uses 64 columns and they are all filled with numbers. Numbers start at line 10. Bottom line sums each column. Macro counts how many rows there are and inserts a line before the line with sums, copies the line before the inserted one into the new one and clears cells. When I start putting numbers into the new line, bottom line sums update automaticaly.

Now, my problem starts when I try to return protection to worksheet, whether I do it manually or with vba code, this action removes all sum formulas from my bottom line.

If anyone knows why this might be happening, please post an answer

Thanks.

[jaslake]

Hi JanezP

I have no idea.

However, if you've not tried this, I suggest you comment out the Application.ScreenUpdating lines of code (both of them) and then step through the code to see what's "Actually" happening. Perhaps the sum formulas are getting cleared here

Please Login or Register  to view this content.

or perhaps not.

John

[JanezP]

I've traced the code and formulas stay in last line until I lock my worksheet with:
Worksheets("Matrika").Protect Password:="kas"

Also formulas disappear when I try to lock them by using excel menus.
Darn strange this is...

[JanezP]

Found it! Formatting on cells was set to hide when locked.. and to think I spent two days figuring out what was wrong..

[jaslake]

Hi JanezP

Glad you figured it out.

John