View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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