Hi
I woudln't use Excel if you have this kind of requirements. Use a
central database with special userforms to access the data
--
Regards
Frank Kabel
Frankfurt, Germany
"Pam Coleman" schrieb im
Newsbeitrag ...
If I have a worksheet and the first seven rows of information I only
want 4
people to access and make changes and then row 8-30, anyone can make
changes.
Is there
a way to do this? I know I can lock cells, protect the sheet and
save as
read only, but if someone opens this and makes changes in the top
part of the
worksheet that shouldn't and print, and even though they can't save
it
without renaming,there are wrong copies going around.So I do not want
these
4 people to change the top at all but everyone can change the bottom
part of
the sheet. Thanks,
|