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/