Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Have the below code to print a sheet, increment a invoice number and remove
protection from sheet, at the moment the passowrd is nothing I nee to change this to qwert and edit the formula to up protect sheet on print and re protect it after the incrementing of the invoice number. Any help would be appreaciated. Sub dayprint() ' ' dayprint Macro ' ' ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Sheet13.Unprotect 'Increment the invoice number [e3] = [e3] + 1 Sheet13.Protect ' Save Macro ' Macro recorded 19/08/2005 ' ' ActiveWorkbook.Save End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Enlarging spread sheet for printing? | Excel Discussion (Misc queries) | |||
Block an area of sheet from Printing? | Excel Discussion (Misc queries) | |||
Copy 1 Sheet to Another | Excel Worksheet Functions | |||
Simple question - one xls sheet keeps printing 6 copies as default | Excel Discussion (Misc queries) | |||
Subset of one sheet on another sheet | Excel Discussion (Misc queries) |