I have a document list that has:

A B C D
E
Co. #1 Co. #2 doc name clip art actual
file path
button w/
hyperlink to doc
X
X

At the top of the list, there is a macro button for Co. #1 and a button for
Co. #2.
If the user wants a doc for Co. #1, they hit their macro button and the
macro shows only rows with docs for Co. #1 and hides all rows with docs for
Co. #2.

Problem - the clipart buttons in col. D that contain the hyperlinks are
shifting downward. How do I lock the clip art buttons to the proper cells?

I protected the sheet but then my macro won't hide rows properly.

Let me know if clarification or more info is needed. thanks in advance! jane