Results 1 to 15 of 15

Stop button flicker going from Print Preview to a sheet.

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    02-26-2010
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2003/2007/2010/2016
    Posts
    432

    Stop button flicker going from Print Preview to a sheet.

    Hello!

    I made this quick labelmaker. The data is on the Data sheet, and on the Form sheet, the user figures out what data (or blank) goes on each label (labels may be duplicated), and then hits a button which brings up the Print Preview/Print of the hidden sheet named Printer.

    The issue I am having is when it goes from Print Preview back to the Form sheet, the buttons appear and it's not smooth. If anyone can improve the code, i'd appreciate it. The pw is "label".

    Thanks!
    Regards,
    leaning
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro slows down when I print/print preview/page break a sheet
    By Grug in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2015, 08:59 PM
  2. Disable Print button in Full Print Preview
    By RaquelAR in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-17-2013, 02:03 PM
  3. VBA Macro shows Print Preview page: How to auto-maximize the Print Preview?
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2010, 04:48 PM
  4. [SOLVED] How do I stop active x controls from moving after a print preview
    By mleavitt in forum Excel General
    Replies: 2
    Last Post: 09-12-2005, 04:05 PM

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