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