Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
print preview-dag johansen
hi there dag!!!
thanks a lot for your response. my problem is slightly different. i need to be able to run the subroutine in the VBA editor that checks if the user is in the print preview mode when the user is actually in teh print preview mode. not just check if he has pressed the print preview button!!!!! but if you try it yourself you will see that the vba editor freeezes. for example open a workbook. press alt-F11. write the simple sub sub hello() msgbox "hello" end sub then go back to the workbook, write something in the worksheet and then print preview it. then switch to the VBA editor. try to run the hello sub. nothing works. you see what i mean? i appreciate any help ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
print preview-dag johansen
As you said, no code runs when you are in print preview, so you can not
interact with the user while in print preview. -- Regards, Tom Ogilvy "nikolaosk" wrote in message ... hi there dag!!! thanks a lot for your response. my problem is slightly different. i need to be able to run the subroutine in the VBA editor that checks if the user is in the print preview mode when the user is actually in teh print preview mode. not just check if he has pressed the print preview button!!!!! but if you try it yourself you will see that the vba editor freeezes. for example open a workbook. press alt-F11. write the simple sub sub hello() msgbox "hello" end sub then go back to the workbook, write something in the worksheet and then print preview it. then switch to the VBA editor. try to run the hello sub. nothing works. you see what i mean? i appreciate any help ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plot Area Automatically Expands in Print and Print Preview | Charts and Charting in Excel | |||
First page of Excel sheerepeats in print layout or print preview | Excel Discussion (Misc queries) | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
print preview v page break preview | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) |