D
Don
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!
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!