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 not sure if you can "turn off" design mode, but when you protect the
sheet, you can prevent the objects from being moved/deleted using:

activesheet.protect DrawingObjects:=True

Dan

" wrote:

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

Hi Dan,

Thank you for your reply. I think we found out what it was. The user
has Macro Security set to high which disables all macros and opens the
workbook in design mode.

Terry


Dan Hatola wrote:
I am not sure if you can "turn off" design mode, but when you protect the
sheet, you can prevent the objects from being moved/deleted using:

activesheet.protect DrawingObjects:=True

Dan

" wrote:

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