button disappears when column is hidden
Rightclick on the button
Select Format Control|Properties tab|check "don't move or size with cells"
Edward wrote:
I have a button that runs a macro that hides columns. I want to make
it flexible so that it can hide any column. No problems there. My
problem is that when I hide the column that my button is in, I also
hide the button. Is there a way to make buttons "float" or not assign
to any column so that I will not lose it? I am just using the
standard button created by going to View-Toolbars-Form and selecting
the button using Excel 2002.
Thanks.
Edward
--
Dave Peterson
|