PC Review


Reply
Thread Tools Rate Thread

Can't get into design mode in Excel 2007

 
 
TomCon
Guest
Posts: n/a
 
      17th Oct 2007
What gives here. I have the developer ribbon showing. Macros are
_definitely_ enabled. When i click the Deisgn Mode button on the developer
ribbon, basically, nothing happens. In either state (pressed or not) for
that button on the developer ribbon, when i use the mouse and press any
macro button that is on a sheet in the workbook, the macro runs. I can't
get to the point where i can select a button, edit its properties, have it
selected to "show code", etc.

Help!! How do i get into design mode in Excel 2007?? Tried
quitting/restart Excel, no luck there.

Thanks,
tom


 
Reply With Quote
 
 
 
 
Ron de Bruin
Guest
Posts: n/a
 
      17th Oct 2007
Are you sure you have a ActiveX button on your sheet and not a Forms button ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"TomCon" <(E-Mail Removed)> wrote in message news:I9vRi.5640$W22.4364@trndny04...
> What gives here. I have the developer ribbon showing. Macros are
> _definitely_ enabled. When i click the Deisgn Mode button on the developer
> ribbon, basically, nothing happens. In either state (pressed or not) for
> that button on the developer ribbon, when i use the mouse and press any
> macro button that is on a sheet in the workbook, the macro runs. I can't
> get to the point where i can select a button, edit its properties, have it
> selected to "show code", etc.
>
> Help!! How do i get into design mode in Excel 2007?? Tried
> quitting/restart Excel, no luck there.
>
> Thanks,
> tom
>
>

 
Reply With Quote
 
TomCon
Guest
Posts: n/a
 
      17th Oct 2007
Oh, i see, its a forms button. I got it there from the insert menu in the
same developer ribbon, but indeed, there are two separate sets of buttons.
I hadn't noticed (still getting used to 2007)

Thanks very much!!!! Its amazing how such a little thing can become a real
block, and somebody slightly stepped away from the problem can solve it!

BUT -----
Can i place an active X button on a chart? From the Insert dropdown of
Developer ribbon, the Acitve X controls are all grayed out if i'm on a
chart, but they are available on a worksheet. So, when on a chart, only the
Forms controls are available to place on the chart. Workaround???

Thanks again!

Tom

"Ron de Bruin" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Are you sure you have a ActiveX button on your sheet and not a Forms
> button ?
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "TomCon" <(E-Mail Removed)> wrote in message
> news:I9vRi.5640$W22.4364@trndny04...
>> What gives here. I have the developer ribbon showing. Macros are
>> _definitely_ enabled. When i click the Deisgn Mode button on the
>> developer ribbon, basically, nothing happens. In either state (pressed
>> or not) for that button on the developer ribbon, when i use the mouse and
>> press any macro button that is on a sheet in the workbook, the macro
>> runs. I can't get to the point where i can select a button, edit its
>> properties, have it selected to "show code", etc.
>>
>> Help!! How do i get into design mode in Excel 2007?? Tried
>> quitting/restart Excel, no luck there.
>>
>> Thanks,
>> tom
>>


 
Reply With Quote
 
Andy Pope
Guest
Posts: n/a
 
      18th Oct 2007
Hi,

No work around. Charts and chartobjects can not contain active-x controls.
This is true for all xl versions.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"TomCon" <(E-Mail Removed)> wrote in message
news:7HvRi.7602$I22.3297@trndny03...
> Oh, i see, its a forms button. I got it there from the insert menu in the
> same developer ribbon, but indeed, there are two separate sets of buttons.
> I hadn't noticed (still getting used to 2007)
>
> Thanks very much!!!! Its amazing how such a little thing can become a
> real block, and somebody slightly stepped away from the problem can solve
> it!
>
> BUT -----
> Can i place an active X button on a chart? From the Insert dropdown of
> Developer ribbon, the Acitve X controls are all grayed out if i'm on a
> chart, but they are available on a worksheet. So, when on a chart, only
> the Forms controls are available to place on the chart. Workaround???
>
> Thanks again!
>
> Tom
>
> "Ron de Bruin" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Are you sure you have a ActiveX button on your sheet and not a Forms
>> button ?
>>
>> --
>>
>> Regards Ron de Bruin
>> http://www.rondebruin.nl/tips.htm
>>
>>
>> "TomCon" <(E-Mail Removed)> wrote in message
>> news:I9vRi.5640$W22.4364@trndny04...
>>> What gives here. I have the developer ribbon showing. Macros are
>>> _definitely_ enabled. When i click the Deisgn Mode button on the
>>> developer ribbon, basically, nothing happens. In either state (pressed
>>> or not) for that button on the developer ribbon, when i use the mouse
>>> and press any macro button that is on a sheet in the workbook, the macro
>>> runs. I can't get to the point where i can select a button, edit its
>>> properties, have it selected to "show code", etc.
>>>
>>> Help!! How do i get into design mode in Excel 2007?? Tried
>>> quitting/restart Excel, no luck there.
>>>
>>> Thanks,
>>> tom
>>>

>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Design Mode Josh Sale Microsoft Excel Programming 3 8th Oct 2009 08:21 AM
Where is Design Mode in ms-word 2007 Mimi Microsoft Word Document Management 5 5th Oct 2009 05:21 AM
web design mode in word 2007 wdk Microsoft Word Document Management 2 18th Mar 2008 03:12 AM
how do I turn on/off "Design mode" in Excel 2007 =?Utf-8?B?ZWFzeWJ1aWxk?= Microsoft Excel Misc 1 28th Jun 2007 07:58 PM
Re: Enter Excel Design Mode and Exit Design Mode Bill Lunney Microsoft Excel Programming 0 4th Aug 2003 07:48 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:33 AM.