Ok I am having 2 problems.
1.The first is I would like to save a file by the filename in 2 seperate folders. one is on a local drive and the other is on a network drive. It needs to happen after data is entered in each cell. The filename changes each month. Instead of adding the macro to each month file i have them in a common .xls file. I can curently do this in one folder but i then have to move it every so often to the other location. here is the macro I am using now.
Sub StopAllEvents()
Application.EnableEvents = False
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Excel.Range)
ThisWorkbook.Save
Application.EnableEvents = True
End Sub
2.When printing the worksheet I have it set to print only the pages that have data listed. However I need the first row (frozen) to print on each sheet. so I get a few pages of data and alot of pages of row one only. Is there a macro that can fix this?
Thanks in advanced for your help
Bookmarks