Thread: Hide Unhide Buttons
View Single Post
  #5  
Old December 26th, 2009, 03:18 PM posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
  
Posts: 6,167
Default Hide Unhide Buttons
ditto

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dave Peterson" wrote in message
...
Check your other post (posts???).

Please decide where you want future responses. Then add a message to the
posts
that tell us (at least me) where we should look for followups.

I'd hate to waste my time finding out that you had the solution you wanted
in a
different group.



Microsoft Communities wrote:

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


--

Dave Peterson