Print Preview

[jjpkraft]

Is there a way to disable the 'Print' and 'Setup' buttons while a user is in the 'Print Preview' view.
I only want them to be able to select 'Close', 'Next' and 'Previous'.

 

[Ivan F Moala]

On 2002-02-28 14:31, jjpkraft wrote:
Is there a way to disable the 'Print' and 'Setup' buttons while a user is in the 'Print Preview' view.
I only want them to be able to select 'Close', 'Next' and 'Previous'.

ActiveWindow.SelectedSheets.PrintPreview False


Ivan

 

[Juan Pablo González]

Ivan, Altough that's a good try, I think I read a post before from him letting users click on the PrintPreview button, BUT, don't allow them to make those changes.

Your solution requires "replacing" that button, doesn't it ?

 

[Guest]

On 2002-02-28 18:10, Juan Pablo G. wrote:
Ivan, Altough that's a good try, I think I read a post before from him letting users click on the PrintPreview button, BUT, don't allow them to make those changes.

Your solution requires "replacing" that button, doesn't it ?

Actually I answered him incorrectly
The solution still allows him to Print...
You are right

Ivan

 

[jjpkraft]

So I guess I'm stuck on this one. I guess the only solution is to disable the ability to print preview until all the required information is obtained.

I hope they create a separate the print preview event in the next version.

Thanks anyway,
Jason