Hi,
I wondered if anyone has had the same problem or if there is a solution?
I have a worksheet with various buttons, which is password protected so the user can only action buttons and their relevant user forms. All the macros refer to active sheet so they can copy the whole sheet and all the buttons as many times as they like. But I have an issue where the new copied sheet works perfectly, but the sheet that was copied kind of locks down so you can't press any buttons, the little pointy finger hand hovers over them but you can't press them. Why is that?
Thanks in advance
I wondered if anyone has had the same problem or if there is a solution?
I have a worksheet with various buttons, which is password protected so the user can only action buttons and their relevant user forms. All the macros refer to active sheet so they can copy the whole sheet and all the buttons as many times as they like. But I have an issue where the new copied sheet works perfectly, but the sheet that was copied kind of locks down so you can't press any buttons, the little pointy finger hand hovers over them but you can't press them. Why is that?
Thanks in advance