I have just added this on a work sheet. It works OK when sheet is unprotected
but when I protect the sheet it comes up error 400. If I select Insert row on
protection box it will insert row but not formulas while protected. How can I
get it to work while sheet is protected.

I have also setup a botton on the taskbar to do this for me but it will only
do it for the day I set it up in. When I save as for the next day it wont
work on the new sheet.
Your help will be appreciated
Regards
Chris

I'm not an expert but I thought the whole idea of protecting the worksheet is
so people do not accidentally change important information like formula.
Don't you protect the formula columns and leave data entry columns
unprotected for the end user?

"Chris" wrote:

I have just added this on a work sheet. It works OK when sheet is unprotected
but when I protect the sheet it comes up error 400. If I select Insert row on
protection box it will insert row but not formulas while protected. How can I
get it to work while sheet is protected.

I have also setup a botton on the taskbar to do this for me but it will only
do it for the day I set it up in. When I save as for the next day it wont
work on the new sheet.
Your help will be appreciated
Regards
Chris

Yes You are correct. But some times there are not enough rows in a section
for the number of items onhand so I need to let other users insert rows to =
that and to remove the cance of upsetting the formulas by mistake. Not all
users are able to input formulas. It will also minimise the cance of the
formulas being left out.
Thanks
Chris

"martin21" wrote:

I'm not an expert but I thought the whole idea of protecting the worksheet is
so people do not accidentally change important information like formula.
Don't you protect the formula columns and leave data entry columns
unprotected for the end user?

"Chris" wrote:

I have just added this on a work sheet. It works OK when sheet is unprotected
but when I protect the sheet it comes up error 400. If I select Insert row on
protection box it will insert row but not formulas while protected. How can I
get it to work while sheet is protected.

I have also setup a botton on the taskbar to do this for me but it will only
do it for the day I set it up in. When I save as for the next day it wont
work on the new sheet.
Your help will be appreciated
Regards
Chris

While trying things to see if I have entered something incorrect I have found
that it works while protected without password but as soon as I protect with
password it wont do the insert rows. (Visual Basics X 400).

"Chris" wrote:

Yes You are correct. But some times there are not enough rows in a section
for the number of items onhand so I need to let other users insert rows to =
that and to remove the cance of upsetting the formulas by mistake. Not all
users are able to input formulas. It will also minimise the cance of the
formulas being left out.
Thanks
Chris

"martin21" wrote:

I'm not an expert but I thought the whole idea of protecting the worksheet is
so people do not accidentally change important information like formula.
Don't you protect the formula columns and leave data entry columns
unprotected for the end user?

"Chris" wrote:

I have just added this on a work sheet. It works OK when sheet is unprotected
but when I protect the sheet it comes up error 400. If I select Insert row on
protection box it will insert row but not formulas while protected. How can I
get it to work while sheet is protected.

I have also setup a botton on the taskbar to do this for me but it will only
do it for the day I set it up in. When I save as for the next day it wont
work on the new sheet.
Your help will be appreciated
Regards
Chris