Recent content by HandleUK

Thanks for this Geoff, I'll give it a go. I'm guessing the attachment is added as a path? PS liked the quote!

I have a spreadsheet which uses VBA to generate an e-mail within the users Lotus Notes account. This is all done via the back door using the code below: HOWEVER, what I'd like to do is paste data directly into the body of the newly created document. I suspect this may be achievable if I use the...

I have a userform to which I have added a print button (uses the .PrintForm Command). However I need to make sure the printer is set to Landscape prior to printing. Does anyone out there know how to do this? Its simple enough with activesheets etc. but userforms...

It may be this simple but without more information I can't be sure. Go to the Tools menu and select OPTIONS. Click on the calculations tab. There is a section on calculation which can be either automatic, automatic except tables and manual. I'd make sure automatic is selected. If this is so...

I have created a VBA userform within Excel which has a spreadsheet control (9.0) inserted onto it. How can I modify the toolbar associated with this web component? Other than hide it or restrict the avaialble controls there seems no way of adding say a print button! I know how to create and...