T
tcnolan
Hi all,
I am working on an excel app and sent the file to another user. We are
both using Excel 2002. I am utilizing command buttons (Control
Toolbox) with macros etc.
When this user opened the file and tried to click a button, it selects
the button. Then he must have double clicked and he started describing
seeing the visual basic editor.
It makes me think that he is in design mode because he can select the
buttons or checkboxes. He did get the "enable macros" warning and
said he clicked "Enable Macros".
Is there a way in VBA to turn off the design mode? Or will protecting
the sheets take care of that? We are still testing so I hadn't turned
on protection yet. I had opened the file on other pcs and this did not
happen. Could he be in design mode by default?
Thanks for any thoughts,
Terry
I am working on an excel app and sent the file to another user. We are
both using Excel 2002. I am utilizing command buttons (Control
Toolbox) with macros etc.
When this user opened the file and tried to click a button, it selects
the button. Then he must have double clicked and he started describing
seeing the visual basic editor.
It makes me think that he is in design mode because he can select the
buttons or checkboxes. He did get the "enable macros" warning and
said he clicked "Enable Macros".
Is there a way in VBA to turn off the design mode? Or will protecting
the sheets take care of that? We are still testing so I hadn't turned
on protection yet. I had opened the file on other pcs and this did not
happen. Could he be in design mode by default?
Thanks for any thoughts,
Terry