Initiating a macro from a control button

  • Thread starter Thread starter TerryM
  • Start date Start date
T

TerryM

I have a large spreadsheet that has two possible ways of viewing by
hiding or unhiding columns. I can write a macro to hide or unhide the
columns. What I am interested in is there a way to control macros for
each view with a control button. Any advice would be very much
appreciated.

TerryM
 
Yes, it is not hard. You could have it such that the button has a state, if
pressed you get one view, if pressed again you get another. Or you could
have click for one view and shift-click for another.

What do you want?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change macro button text when macro is invoked. 2
VB Code to hide rows 3
Macro for Hiding one column at a time in a range 2
Hide, unhide macro 19
VB code 4
Macro to Hide/Unhide various columns 5
Toggling xlVeryHidden 8
toggle button in excel 4

Back
Top