Filling menu items

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

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
 
ActiveWorkbook.BuiltinDocumentProperties("Title").Value = "My Title"


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
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
 
Thanks a lot for your help.

Tom

Ken said:
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
Click to expand...
 
Thanks a lot for your help

Tom

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


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
Back
Top