hi there folks!!!

i am working on a project that uses vba scripts to test features of

excel.


my problem is this.

i have to check if the user has inserted a header and aligned it right
in a specific worksheet.



i can do that no problem.


then i am asked to check if the user has hit the print preview button
and that the worksheet is in the print preview mode.



when i record a macro that puts a workesheet in print preview what i
get from the recorded macro is this


ActiveWindow.SelectedSheets.PrintPreview.



how can i check that the user has left his worksheet in print preview
mode?


i hope you understand


please help!!!!!!!!!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Nikolaos,

query the Printpreview property of the relevant sheet,
like this:

Dim PPviewOn as boolean

If activesheet.printpreview = true then
PPview = True
... your code here ...
Else
PPview = False
... alternative code here ...
End IF

Cheers, Pete

That always returned false for me - of course printpreview doesn't return
anything until the sheet is out of printprint preview.

--
Regards,
Tom Ogilvy

"Pete McCosh" wrote in message
...
Nikolaos,

query the Printpreview property of the relevant sheet,
like this:

Dim PPviewOn as boolean

If activesheet.printpreview = true then
PPview = True
... your code here ...
Else
PPview = False
... alternative code here ...
End IF

Cheers, Pete

Ah...

I didn't realise that, I just played around with querying
the value and setting it to true, then made up the rest of
my example without actually trying it. That should be a
lesson for me!

After a brief interlude, I now see that the VBE is
disabled when in Print preview mode. Is there any way for
Nikoloas to do what he wants?

Pete

-----Original Message-----
That always returned false for me - of course
printpreview doesn't return
anything until the sheet is out of printprint preview.

--
Regards,
Tom Ogilvy

I don't think the object model provides any direct way to do that. I
believe any workaround would depend on detecting the user initiating a
command that would take them into printpreview mode.

--
Regards,
Tom Ogilvy

"Pete McCosh" wrote in message
...
Ah...

I didn't realise that, I just played around with querying
the value and setting it to true, then made up the rest of
my example without actually trying it. That should be a
lesson for me!

After a brief interlude, I now see that the VBE is
disabled when in Print preview mode. Is there any way for
Nikoloas to do what he wants?

Pete

-----Original Message-----
That always returned false for me - of course
printpreview doesn't return
anything until the sheet is out of printprint preview.

--
Regards,
Tom Ogilvy