B
BlockNinja
I have a form in which I want to have a graph that updates dynamically as the
user changes criteria via dropdowns, radio buttons, listboxes, etc. This
code works just fine. The only problem is that I do not want the user to be
able to change the layout and have it save as a permanent change (if I can
get them to not be able to change the layout altogether that would be
perfect).
I inserted the chart via Insert -> Chart on the toolbar, and now I have a
nice chart laid out the way I want it. Unfortunately, it comes in as an OLE
object... yay... So to keep the user from saving changes to the graph (of
course, they can still edit the graph object unfortunately), I set the Locked
property to Yes/True.
Only problem with this is that it pops up an annoying message whenever the
user first enters the form that says "The object is locked, so any changes
you make will be discarded when the form is closed. Click Save As/Export on
the File menu and save the object under a different name."
Is there any way to get rid of this message? Better yet, is there a way to
keep the user from editing the object altogether? It always come up in the
form with some ugly black selection handles around it, regardless of whether
or not the user has that object selected. I'd like if at all possible to
keep the users from toying with this layout, messing it up, and then the next
user comes and starts complaining that it is messed up.
user changes criteria via dropdowns, radio buttons, listboxes, etc. This
code works just fine. The only problem is that I do not want the user to be
able to change the layout and have it save as a permanent change (if I can
get them to not be able to change the layout altogether that would be
perfect).
I inserted the chart via Insert -> Chart on the toolbar, and now I have a
nice chart laid out the way I want it. Unfortunately, it comes in as an OLE
object... yay... So to keep the user from saving changes to the graph (of
course, they can still edit the graph object unfortunately), I set the Locked
property to Yes/True.
Only problem with this is that it pops up an annoying message whenever the
user first enters the form that says "The object is locked, so any changes
you make will be discarded when the form is closed. Click Save As/Export on
the File menu and save the object under a different name."
Is there any way to get rid of this message? Better yet, is there a way to
keep the user from editing the object altogether? It always come up in the
form with some ugly black selection handles around it, regardless of whether
or not the user has that object selected. I'd like if at all possible to
keep the users from toying with this layout, messing it up, and then the next
user comes and starts complaining that it is messed up.