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