Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default How do we add a separator in Excel 2007 menu using VBA

Can you please help me on this.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,726
Default How do we add a separator in Excel 2007 menu using VBA

I don't believe that you can, you use groups in 2007.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Suman" wrote in message
...
Can you please help me on this.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default How do we add a separator in Excel 2007 menu using VBA

I want to separate the menu items using the 'separator' using VBA at run time.

"Bob Phillips" wrote:

I don't believe that you can, you use groups in 2007.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Suman" wrote in message
...
Can you please help me on this.




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,726
Default How do we add a separator in Excel 2007 menu using VBA

Well you repeated yourself, so I will repeat myself.



I don't believe that you can, you use groups in 2007.


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Suman" wrote in message
...
I want to separate the menu items using the 'separator' using VBA at run
time.

"Bob Phillips" wrote:

I don't believe that you can, you use groups in 2007.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Suman" wrote in message
...
Can you please help me on this.






  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default How do we add a separator in Excel 2007 menu using VBA

Fine. Can you please elaborate/ provide links to do it using groups. Thanks
so much in advance.

"Bob Phillips" wrote:

Well you repeated yourself, so I will repeat myself.



I don't believe that you can, you use groups in 2007.


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Suman" wrote in message
...
I want to separate the menu items using the 'separator' using VBA at run
time.

"Bob Phillips" wrote:

I don't believe that you can, you use groups in 2007.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Suman" wrote in message
...
Can you please help me on this.








  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default How do we add a separator in Excel 2007 menu using VBA

The groups are not programmable using VBA. One of the biggest features,
well, they call it a feature, is the new user interface, which is based on
XML.

You can start reading about the new interface he

http://office.microsoft.com/en-us/pr...679411033.aspx
http://blogs.msdn.com/jensenh/archiv...09/547281.aspx

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Suman" wrote in message
...
Fine. Can you please elaborate/ provide links to do it using groups.
Thanks
so much in advance.

"Bob Phillips" wrote:

Well you repeated yourself, so I will repeat myself.



I don't believe that you can, you use groups in 2007.


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Suman" wrote in message
...
I want to separate the menu items using the 'separator' using VBA at
run
time.

"Bob Phillips" wrote:

I don't believe that you can, you use groups in 2007.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Suman" wrote in message
...
Can you please help me on this.








  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default How do we add a separator in Excel 2007 menu using VBA

Thanks so much for the info.

"Jon Peltier" wrote:

The groups are not programmable using VBA. One of the biggest features,
well, they call it a feature, is the new user interface, which is based on
XML.

You can start reading about the new interface he

http://office.microsoft.com/en-us/pr...679411033.aspx
http://blogs.msdn.com/jensenh/archiv...09/547281.aspx

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Suman" wrote in message
...
Fine. Can you please elaborate/ provide links to do it using groups.
Thanks
so much in advance.

"Bob Phillips" wrote:

Well you repeated yourself, so I will repeat myself.



I don't believe that you can, you use groups in 2007.


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Suman" wrote in message
...
I want to separate the menu items using the 'separator' using VBA at
run
time.

"Bob Phillips" wrote:

I don't believe that you can, you use groups in 2007.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Suman" wrote in message
...
Can you please help me on this.









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
Excel 2007 Date Format Problem terry Excel Discussion (Misc queries) 0 November 25th 06 06:16 AM
Excel 2007 Error Reopening Pivot tables Mike L Setting up and Configuration of Excel 6 November 24th 06 09:53 PM
Problematic chart issues in Excel 2007 azbull Charts and Charting in Excel 1 October 2nd 06 03:35 PM
Excel 2007 - Custom menus is missing! Søren Thade Petersen Excel Discussion (Misc queries) 3 July 11th 06 01:59 AM
Excel 2007 Nick Hodge Excel Discussion (Misc queries) 0 July 5th 06 08:49 PM


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