I appreciate your response and I think I understand what you are saying but I
don't want to do that. If I go that far I would just create a
VB app. which
is a long range plan.
Reason being is that today I supply the starting base excel spreadsheet to
which the users can add their own functions. However, there are some
thing(cells) that I do not allow them to alter.
After much searching I did find information on protecting and unprotecting
worksheets in VBA. So I can turn protecion on and off. However, that takes
away a lot ofthe functions a user can do on that worksheet.
I was hoping for some other method to control altering individual cells.
Thanks forthe response,
--
Kermit, long time windows Office user
"Office_Novice" wrote:
A modal form is likely your best option. A little more info would allow me to
help more.
"Kermitp" wrote:
I am working a project where I want to limit the user changes via either a
form or a macro. In other words I do not want the user to be able to alter a
cell's content directly.
I know I could hide the worksheet or columns but the user has to be able to
view their content without directly altering them.
I tried locking the cells and password protecting the worksheet but then
when I attempt to clear the cell content via macro I get an error message.
Is there way to set the cell property for protection or no protection? I have
searched help without much success.
Error message:
Run-time error '1004':
The cell or chart that you are trying to change is protected and
therefore read-only.
To modify a protected cell or chart, first remove protection using the
Unprotect Sheet command (Review tab, Changes group). You may be
prompted for a password
--
Kermit, long time windows Office user