Hi there,
this sounds so simple and not sure what I am doing wrong.
I have a spreadsheet that I want to protect and on the spreadsheet I have 2 form control buttons that allows the use to choose between Headcount or WTE, calculates various sumproducts but by protecting sheet hides formula and only allows users to click on cells I want them to. It all works fine with the buttons until I try and protect my worksheet.
I assigned a macro to each button
I unlocked the protection on each button then protected the sheet but for some reason it does not run the macro and allow me to use the buttons.
I would appreciate any advice as not sure what I am doing wrong.
regards
ian
this sounds so simple and not sure what I am doing wrong.
I have a spreadsheet that I want to protect and on the spreadsheet I have 2 form control buttons that allows the use to choose between Headcount or WTE, calculates various sumproducts but by protecting sheet hides formula and only allows users to click on cells I want them to. It all works fine with the buttons until I try and protect my worksheet.
I assigned a macro to each button
I unlocked the protection on each button then protected the sheet but for some reason it does not run the macro and allow me to use the buttons.
I would appreciate any advice as not sure what I am doing wrong.
regards
ian
