Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printer Set Up in VBA
Hi
I am rather new to this so any advice is greatly appreciated. I am trying to set up a macro which creates a sheet for the user based on their input. My main stumbling block is entering the required text as a header in the print-page set up. I would like to be able to take a string of text from a cell reference and use it ( or part of it) as a title for the document. I have been working on this for without success for sometime now. Thanks in advance Mike --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printer Set Up in VBA
Hi PostalVote
Try this It will add a sheet to your workbook And use cell A1 if the activesheet in the footer (or header) Sub test() Dim Aws As Worksheet Dim Nws As Worksheet Set Aws = ActiveSheet Set Nws = Worksheets.Add With Nws .PageSetup.LeftFooter = Aws.Range("a1").Value End With End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "PostalVote " wrote in message ... Hi I am rather new to this so any advice is greatly appreciated. I am trying to set up a macro which creates a sheet for the user based on their input. My main stumbling block is entering the required text as a header in the print-page set up. I would like to be able to take a string of text from a cell reference and use it ( or part of it) as a title for the document. I have been working on this for without success for sometime now. Thanks in advance Mike --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printer Set Up in VBA
Try this, it takes all of name from cell reference C5 and puts it t
centerheader. Sub Macro1() Dim TitleOfDocument As String 'set variable titleofdocument to be value of cell C5 TitleOfDocument = Cells(5, 3).Value ' With ActiveSheet.PageSetup .CenterHeader = TitleOfDocument End With End Su -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printer Set Up in VBA
Worked an absolute treat, exactly what I was looking for.
Many thanks Mik -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printer | Excel Discussion (Misc queries) | |||
members on my network printer not able to print to default printer | Excel Discussion (Misc queries) | |||
Printer Multiple Worksheets with a particular Printer Setting | Excel Worksheet Functions | |||
Printing with B&W printer | Excel Discussion (Misc queries) | |||
Printer Settings | Excel Programming |