View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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,