greying-out Excel cells

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
 
L

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.
 
D

Don Guillett

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top