I am very new to excel and I have been asked to create a very basic macro through the use of buttons.
I have 2 sheets in my workbook. I basically need to create a button on sheet 2 that will hide columns in sheet 1. I need this button to also prompt the user to click on button 2 to unhide the columns </SPAN>when they are finished imputting their data.
Some guidance here would be greatly appreciated, creating the macro itself seems easy enough using record macro but I am having trouble with linking it to a button on a seperate sheet.
Thanks!
I have 2 sheets in my workbook. I basically need to create a button on sheet 2 that will hide columns in sheet 1. I need this button to also prompt the user to click on button 2 to unhide the columns </SPAN>when they are finished imputting their data.
Some guidance here would be greatly appreciated, creating the macro itself seems easy enough using record macro but I am having trouble with linking it to a button on a seperate sheet.
Thanks!