Filling menu items
 

I was wondering if it is possible to fill menu items in Excel based on
certain condtions using VB. For example, I need a macro to go into the

Properties menu item under the File menu and insert a string into the
Title box (in Excel). Is this possible? And if so, how would one go
about this? Thanks for the help

Tom

Filling menu items
 

ActiveWorkbook.BuiltinDocumentProperties("Title"). Value = "My Title"


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"tom" wrote in message
ups.com...
I was wondering if it is possible to fill menu items in Excel based on
certain condtions using VB. For example, I need a macro to go into the

Properties menu item under the File menu and insert a string into the
Title box (in Excel). Is this possible? And if so, how would one go
about this? Thanks for the help

Tom

Filling menu items
 

Actually, navigating the menu structure to do this would be a difficult
an unreliable method. You're better to find the object that you need to
modify. In this case it is:

ThisWorkbook.BuiltinDocumentProperties("Title") = "My Custom Title"

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

tom wrote:
I was wondering if it is possible to fill menu items in Excel based on
certain condtions using VB. For example, I need a macro to go into the

Properties menu item under the File menu and insert a string into the
Title box (in Excel). Is this possible? And if so, how would one go
about this? Thanks for the help

Tom

Filling menu items
 

Thanks a lot for your help.

Tom

Ken Puls wrote:
Actually, navigating the menu structure to do this would be a difficult
an unreliable method. You're better to find the object that you need to
modify. In this case it is:

ThisWorkbook.BuiltinDocumentProperties("Title") = "My Custom Title"

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

tom wrote:
I was wondering if it is possible to fill menu items in Excel based on
certain condtions using VB. For example, I need a macro to go into the

Properties menu item under the File menu and insert a string into the
Title box (in Excel). Is this possible? And if so, how would one go
about this? Thanks for the help

Tom

Filling menu items
 

Thanks a lot for your help

Tom

Bob Phillips wrote:
ActiveWorkbook.BuiltinDocumentProperties("Title"). Value = "My Title"


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"tom" wrote in message
ups.com...
I was wondering if it is possible to fill menu items in Excel based on
certain condtions using VB. For example, I need a macro to go into the

Properties menu item under the File menu and insert a string into the
Title box (in Excel). Is this possible? And if so, how would one go
about this? Thanks for the help

Tom