Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default workbook opens in design mode

Hi
I developed a workbook with few controls from the control toolbox. It opens fine for me and Iam able to navigate using th
command buttons and the combo box. But for few select users, The workbook opens the controls in the sheet in design mode. I checked to make sure the control toolbox is not open in design mode. But Iam not able to figure why it is openin
in design mode for some of the users. ANy ideas would be greatly appreciated. I spent quite a bit of time in the foru
to see if anybody has reported this problem and found none

thank
Kanan
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default workbook opens in design mode

Could it be that the workbook was saved with one of the control
selected/active ?

I use 'ActiveSheet.Range("A1").Select' frequently to ensure tha
controls lose focus

--
Message posted from http://www.ExcelForum.com

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default workbook opens in design mode

that may be a possibility. Not 100% sure. I found out that if somebody has macro security level set at High, the workboo
goes into design mode when opened with an error message box indicating macros were not executed. But I still have one user with this problem even after setting macro security level to medium and answers yes to enable macros. its puzzlin
indeed
kanan
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
Design Mode button rodlmiller Excel Discussion (Misc queries) 1 May 13th 09 10:33 PM
Design Mode Oldjay Excel Discussion (Misc queries) 6 May 9th 08 12:31 AM
Design Mode - or something like it. C Brandt Excel Discussion (Misc queries) 1 August 13th 07 07:08 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 09:13 AM.

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"