+ Reply to Thread
Results 1 to 6 of 6

save as and print options macro

Hybrid View

  1. #1
    Registered User
    Join Date
    11-22-2007
    Posts
    8

    save as and print options macro

    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

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello ramblin racer.

    Welcome to the Forum! As a member, you now have full access to the knowledge and posting tools that make this site unique.

    In order to provide you with prompt replies to your questions, there are a few rules we ask that you observe. Please remember to follow these rules when you post as a courtesy to your fellow members, and to those who are volunteering their time, and knowledge.

    Readability is key in getting a fast response to your question. You have many tools available to assist you in formatting your post. Any code you post, whether a worksheet formula or VBA code should be wrapped. You can find a list of other HTML format options in the forum rules.

    How to Wrap your Code
    On the Message window Toolbar you will see the # icon. Select the text you want to appear in a Code Window, and Click the # icon. This will wrap the code for you. You can also do this manually by placing the tag [code] at the beginning of the first the line, and the tag [/code] at the end of the last line.

    You can read the Forum rules by clicking on the link below.
    Forum Rules
    If you have any questions, contact me by clicking on my name Leith Ross

    Sincerely,
    Leith Ross

  3. #3
    Registered User
    Join Date
    11-22-2007
    Posts
    8
    Thanks Leith, My appologies.

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello ramblin racer,

    No need to apologize, you are new to the forum. Hope the instructions were clear and easy to follow. If not, let me know.

    Thanks,
    Leith

  5. #5
    Registered User
    Join Date
    11-22-2007
    Posts
    8

    Question

    So any ideas on how to do this?

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1