clip art shifts
 

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

clip art shifts
 

Try this: right-click on the clipart image and select "Size and Properties".
Choose the Properties tab and click on the "Don't move or size with cells"
check box. I had some buttons in a project of mine that would move as I hid
rows, and this solved the problem.

HTH
Bill

"jane" wrote:

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