LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default turn off design mode

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

 
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
how do I turn on/off "Design mode" in Excel 2007 easybuild Excel Discussion (Misc queries) 2 April 3rd 23 11:10 AM
how to turn off design mode Paul Excel Worksheet Functions 2 September 23rd 05 01:10 PM
Hyperlinks Inserted in Design Mode inactive once Exited Design Mod Craig Excel Programming 0 March 16th 05 04:53 PM
Combo Box goes to edit mode even if design mode is in OFF position Chas Excel Discussion (Misc queries) 0 January 7th 05 07:21 PM
Enter Excel Design Mode and Exit Design Mode Bill Lunney Excel Programming 0 August 4th 03 07:48 AM


All times are GMT +1. The time now is 12:25 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"