close

I have a sheet where all the formulas must be preserved exactly, but I want
users to be able to delete rows with cells containing those protected
formulas. Is this possible?

Maybe you could give them a macro that would unprotect the worksheet, do the row
deletion and then reprotect the worksheet.

You could even build checks into your code that only certain rows can be
deleted.

Hubitron2000 wrote:
gt;
gt; I have a sheet where all the formulas must be preserved exactly, but I want
gt; users to be able to delete rows with cells containing those protected
gt; formulas. Is this possible?

--

Dave Peterson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()