+ Reply to Thread
Results 1 to 2 of 2

Hide buttons when clicking

  1. #1
    Registered User
    Join Date
    12-17-2015
    Location
    New Hampshire
    MS-Off Ver
    2016
    Posts
    34

    Hide buttons when clicking

    I have this spreadsheet I made that has macro's buttons on it. This is probably really simple I just haven't been able to do it right. When I click the button to print the schedule or even the other one, I don't want those 2 buttons to show when printed. I want them hidden so it's either 2 empty boxes there or blank. Anyway to do this?

  2. #2
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: Hide buttons when clicking

    try right clicking the buttons
    format auto shape
    properties
    print object - deselect
    Regards
    Sean

    Please add to my reputation if you think i helped
    (click on the star below the post)
    Mark threads as "Solved" if you have your answer
    (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code:
    [code] Your code here [code]
    Please supply a workbook containing example Data:
    It makes its easier to answer your problem & saves time!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hide and Unhide Rows by clicking a cell.
    By Mathewj in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2015, 01:30 AM
  2. [SOLVED] Hide/Unhide Rows when clicking between two tabs in Workbook
    By jdesro04 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2014, 09:23 PM
  3. [SOLVED] Addin W/ Ribbon: Restict Users from clicking buttons from wrong sheet.
    By sud123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-12-2013, 05:33 PM
  4. Replies: 3
    Last Post: 02-28-2012, 02:05 PM
  5. Hide a column by clicking on a cell or using a hot key?
    By simonwilliams in forum Excel General
    Replies: 6
    Last Post: 12-02-2009, 07:16 AM
  6. Entering input and clicking buttons during loop
    By FlyinJack in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2009, 07:47 PM
  7. [SOLVED] hide column on double clicking certain cell
    By bta in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-01-2009, 09:05 AM

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