greying-out Excel cells

  • Thread starter Thread starter Louise
  • Start date Start date
L

Louise

Dear all

I have an Excel worksheet that contains holiday
information for my department. I want to e-mail this out
to my colleagues for them to fill their holidays in,
however, I do not want them to be able to access any
cells other than those containing the holiday information.

I don't just want to Protect the cells, I believe there
is a way you can "grey out" the rows/columns that you do
not want to use, so the users cannot scroll down the
worksheet etc.

Does anybody know how I can do this, rather than
physically deleting all the unwanted rows?

Thanks for any help.

Louise
 
Thanks for your reply, however, don't quite understand
what I need to do.

I have tried entering scrollarea = a1:f10 and it doesn't
make any difference. Do I enter this into a particular
cell etc. It doesn't seem to have worked.

Thanks.
 
alt f11>find the name of your workbook>open the module area>copy/paste this.

sub setscrollarea()
sheets("yoursheeetname").ScrollArea = "a1:f10"
end sub

If you want to re-set use
sub unsetscrollarea()
sheets("yoursheeetname").ScrollArea = ""
end sub
 
Back
Top