I have a shape that I assigned a macro to on a sheet which delets rows and columns where the shape sits.
is there a work around to not have the shape effected by whats going on in the worksheet when i click on the shape/button to run the macro?
I have a shape that I assigned a macro to on a sheet which delets rows and columns where the shape sits.
is there a work around to not have the shape effected by whats going on in the worksheet when i click on the shape/button to run the macro?
right click the shape and go to properties/ Format control and check "Don't move or size with cells"
!If all your troubles are solved, then so is the thread. Show this by marking it so using thread tools at the top of the page.
If I helped do this, then please show your appreciation by awarding rep points.
<------ Button for that is over there
Thank You Marking this as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks