Editing a protected sheet
There are no macros running.
"Mike Fogleman" wrote in message
news:1juad.159502$wV.80766@attbi_s54...
Is there a Change Event macro running for that sheet?
"Govind Rathi" wrote in message
...
Frank,
Thanks for your reply, I do have that cell unlocked.
My problem is user should be able to edit the cell,
user can enter anything into the cell as of now but when they try to
edit
the content entered by them the cell is cleared automatically and they
have
to enter the complete text again.
I hope I am clear in my requirement.
Thanks,
Govind.
"Frank Kabel" wrote in message
...
Hi
- first select this cell before protecting the sheet
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- now protect your sheet
-----Original Message-----
Hi All,
My requirement is that users should be able to edit a
cell in a protected
work sheet.
Currently, when a user tries to edit the cell the content
of the cell goes
off.
Any help is appreciated. I am running Excel 2000.
Thanks,
Govind.
.
|