Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Printing the macro button

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    After putting in a button on my worksheet, I've assigned a macro on it. Now I'm trying to print the sheet wif the button but my print preview doesn't show the button. So I just printed it out to check whether the button would then be printed. But it still is not printed out. How come the buttons do not come out on the print preview when the buttons do exist in the worksheet. Can someone pls help me so that I am able to print out the buttons in my worksheet?

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Right click the button and choose format control. Check the print object box on the properties tab.
    Veni, Vidi, Velcro - I came, I saw, I stuck around

    Taxation WITH representation ain't so hot either

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Birmingham, Al
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you right-click the button on your sheet and select "format control", then choose the properties tab, you'll see a check box as the last choice "Printable object", or something close. if this is selected, your button should show up when you print the worksheet...

    That it?

    neo

  4. #4
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-07 06:34, choungeehowe wrote:
    After putting in a button on my worksheet, I've assigned a macro on it. Now I'm trying to print the sheet wif the button but my print preview doesn't show the button. So I just printed it out to check whether the button would then be printed. But it still is not printed out. How come the buttons do not come out on the print preview when the buttons do exist in the worksheet. Can someone pls help me so that I am able to print out the buttons in my worksheet?
    Right click on your button (I'm assuming it's a form button), select Format Control, select the Properties tab, and check off the Print Object check box.


    Well it looks like I'm the bronze medalist on this question


    Regards,


    _________________

    Barrie Davidson
    My Excel Web Page

    [ This Message was edited by: Barrie Davidson on 2002-03-07 06:41 ]

  5. #5
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yeah but the French judge may have been on the take. You most likely deserved the gold!
    Veni, Vidi, Velcro - I came, I saw, I stuck around

    Taxation WITH representation ain't so hot either

  6. #6
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-07 10:26, Steve Hartman wrote:
    Yeah but the French judge may have been on the take. You most likely deserved the gold! [img]/board/images/smiles/icon_lol.gif[/img]
    You know, you may have something there!! I wonder who I need to bribe to ensure gold from now on.


    PS - thanks for the laugh, it's been a rough couple of days and that's just what I needed.
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  7. #7
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Barrie,

    It's 80 degrees and sunny here!!!

    Brian

  8. #8
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-07 16:21, Brian from Maui wrote:
    Barrie,

    It's 80 degrees and sunny here!!!

    Brian
    Ouch, you don't know how hard it is to read that when it's cold and white outside

    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  9. #9
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I went to college at Michigan State and my freshman year there was a guy on my dorm floor from Hawaii. We asked him WHY he left paradise to go to school in Michigan. He said he wanted to experience something different. One 12 degree F January morning with two feet of snow on the ground and more falling, I came across him standing on the sidewalk staring into the sky and mumbling over and over "What was I thinking?"

Some videos you may like

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
  •