Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 drawing objects problems in Excel 2007... | Excel Discussion (Misc queries) | |||
Drawing Objects | Excel Programming | |||
Cutting Drawing Objects | Excel Discussion (Misc queries) | |||
HOW DO I KEEP DRAWING OBJECTS ANCHORED? | Excel Discussion (Misc queries) | |||
[Q] parameters to drawing objects | Excel Programming |