Excel button protection RRS feed

  • Question

  • Hi,

    I created an excel sheet with quadrant maps. so there is a drop down list with total and sub groups so in order to see specific data you can select filter in the drop down list. with this I added a button which can move the axis of quadrant maps with respect to average of group of data.  so after selecting specific data filter in drop down quad map automatically change the data points on maps then you have to press the button so axis move accordingly. I am trying to protect the sheet but once I protect sheet and press the button it gives macro error. any body can help me to fixed that issue so i would not get the macro error?

    I dont know what forum to select also guide me if this is not the right forum to ask.
    • Edited by Abbas madad Monday, October 1, 2018 8:20 PM
    Monday, October 1, 2018 8:19 PM