View Single Post
  #1  
Old December 26th, 2009, 12:29 PM posted to microsoft.public.excel.misc
Microsoft Communities
external usenet poster
 
Posts: 1
Default Hide Unhide Buttons

This is a two fold question:
Q1

I have a situation where a button resides in 2 of 4 columns that hidden
until needed.
When I hide the columns it appears that the button is sized where when I
unhide the columns the button does not show.
Is there a way in a macro that I can size and place the button where I want
it.
Example the button is called "Reset" and it calls a reset macro. It reside
in columns H and J, Columns G through L are hidden until needed. The button
takes up the cells H20 through J21.

Q2
I would like to be able to Hide or Unhide a button using the Text Label Not
the button number.

Thanks for your help