Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default problems using printout method in excel 2007

I have written code to automatically do a proper pagesetup and then show a
print preview (someworksheet.printout preview:=true) to the user. I have
assigned this code to a button in a custom menubar.

when running the code (from the custum munobar) the user sees the
printpreview screen but all the print-buttons that are normally there in the
preview screen are gone
(for setup, margins, print etc). So the user has no means at all to print
from this preview screen. The only thing that works is the escape-button to
go back to normal layout screen. Do I have to manually set the proper menubar
in my code or is there another way around this ?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with PrintOut Method Prasad Excel Programming 2 April 4th 07 03:10 PM
Deselecting sheets after the PrintOut method [email protected] Excel Programming 1 September 3rd 05 12:29 AM
Problems with Printout Method No Name Excel Programming 0 March 3rd 05 04:33 PM
Printout method: in color, duplex [email protected] Excel Programming 3 January 4th 05 08:55 PM
Excel vba printout method Curtis[_4_] Excel Programming 11 October 28th 03 01:15 PM


All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"