Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 drawing objects problems in Excel 2007... R. F. Collins III Excel Discussion (Misc queries) 1 August 6th 09 06:48 PM
Drawing Objects pan65 Excel Programming 4 September 4th 06 03:16 AM
Cutting Drawing Objects LostNFound Excel Discussion (Misc queries) 3 August 12th 05 05:35 PM
HOW DO I KEEP DRAWING OBJECTS ANCHORED? HOW DO I KEEP DRAWING OBJECTS ANCHORED? Excel Discussion (Misc queries) 1 May 20th 05 01:35 PM
[Q] parameters to drawing objects Rolf Marvin Bøe Lindgren Excel Programming 1 May 12th 04 10:20 AM


All times are GMT +1. The time now is 12:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"