In a coded excel sheet:
I have a unique problem that occurs on an excel sheet that I print to a pdf. During the print function, I unprotect the sheet, then hide the first 50 rows of data in the sheet that I do not want to show in the pdf print. That first 50 rows contains, besides data, about 23 buttons. Once the printing is completed, I then unhide the first 50 rows and protect the sheet again. At that point all but 4 of the buttons inactive and no longer function. If I click on them, there is no response. I have compared properties in the ones that do not work with the 4 that do, and there are no differences.
I have found a simple work around, by unprotecting the sheet, using developer / design mode and then selecting the ones that no longer work. I then simply move them a couple of positions and then return them to their original positions, then protect the sheet again. I recorded these steps and just call it tickle. Then the buttons become active again.
Is there something that I am overlooking that might cause this issue?
OH, I forgot to mention that I have also tried making the buttons invisible and back, still the same problem occurs.
Bookmarks