![]() |
Protect Drawing Objects bug in 2003?
I apologize in advance for posting this discussion if it has already
been addressed in another thread. I have been searching for quite some time with no avail. I am working with a two-sheet workbook with everything protected except unlocked cells on both sheets. On one sheet, all of my forms buttons work properly: they perform the macros assigned to then while keeping position and text locked. The user cannot right click on the buttons or select them. On my other sheet, I have the same protection setting applied, but I cannot click any of my forms command buttons to run their macros. The only difference between the two pages, as far as forms controls are concerned, is that the sheet that is not working properly also has forms radio buttons. If I set the DrawingObjects argument of the sheet.protect method to false, the user can right click on controls on the tab as well as move them around, which I do not want. I have tried unprotecting and reprotecting both sheets, yielding the same results: one sheet works and the other doesn't. I am programming in 2007, but testing in 2003 where most users will be using the app. This bug only occurs in Excel 2003. Is there actually a bug here? Am I doing something wrong? Is there a work around? I have my back against the wall on this one. Any help would be greatly appreciated! |
All times are GMT +1. The time now is 05:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com