macro question
macro question
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: macro question

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Massachusetts, USA
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a very simple macro which includes as part of the code entering page setup (print preview) and deleting the footer (the other spreadsheets have an automatic footer when the file is opened).

    Everything works fine except the macro stops on the print preview screen. When I recorded the macro, the keystrokes included closing the print preview and selecting cell A1???

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You don't need to enter Print Preview to do that. You can get the same result using Page Setup from the File menu.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Massachusetts, USA
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I re-recorded the macro as suggested, worked fine. THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com