How do we add a separator in Excel 2007 menu using VBA
 

Can you please help me on this.

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.

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.

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.

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.

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.

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.