| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWindow size?
Hi All.........
I am doing a routine that runs best with the ActiveWindow.zoom = 100 What I would like, is to be able to determine what the ActiveWindow.Zoom setting actually is prior to running my routine, so I can change it to 100, run the routine, and then change it back to whatever it was.......... Any help would be much appreciated........ Vaya con Dios, Chuck, CABGx3 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWindow size?
Sub activewindowzoom()
oldzoom = ActiveWindow.Zoom ' MsgBox oldzoom ActiveWindow.Zoom = 100 MsgBox "hi there" ActiveWindow.Zoom = oldzoom End Sub -- Don Guillett SalesAid Software "CLR" wrote in message ... Hi All......... I am doing a routine that runs best with the ActiveWindow.zoom = 100 What I would like, is to be able to determine what the ActiveWindow.Zoom setting actually is prior to running my routine, so I can change it to 100, run the routine, and then change it back to whatever it was.......... Any help would be much appreciated........ Vaya con Dios, Chuck, CABGx3 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWindow size?
Thanks Don, that does it nicely for me.
Vaya con Dios, Chuck, CABGx3 "Don Guillett" wrote in message ... Sub activewindowzoom() oldzoom = ActiveWindow.Zoom ' MsgBox oldzoom ActiveWindow.Zoom = 100 MsgBox "hi there" ActiveWindow.Zoom = oldzoom End Sub -- Don Guillett SalesAid Software "CLR" wrote in message ... Hi All......... I am doing a routine that runs best with the ActiveWindow.zoom = 100 What I would like, is to be able to determine what the ActiveWindow.Zoom setting actually is prior to running my routine, so I can change it to 100, run the routine, and then change it back to whatever it was.......... Any help would be much appreciated........ Vaya con Dios, Chuck, CABGx3 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWindow size?
? activewindow.Zoom
100 -- Regards, Tom Ogilvy "CLR" wrote in message ... Hi All......... I am doing a routine that runs best with the ActiveWindow.zoom = 100 What I would like, is to be able to determine what the ActiveWindow.Zoom setting actually is prior to running my routine, so I can change it to 100, run the routine, and then change it back to whatever it was.......... Any help would be much appreciated........ Vaya con Dios, Chuck, CABGx3 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWindow size?
Thanks for the response Tom, but Don already got me there.......
Vaya con Dios, Chuck, CABGx3 "Tom Ogilvy" wrote in message ... ? activewindow.Zoom 100 -- Regards, Tom Ogilvy "CLR" wrote in message ... Hi All......... I am doing a routine that runs best with the ActiveWindow.zoom = 100 What I would like, is to be able to determine what the ActiveWindow.Zoom setting actually is prior to running my routine, so I can change it to 100, run the routine, and then change it back to whatever it was.......... Any help would be much appreciated........ Vaya con Dios, Chuck, CABGx3 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWindow size?
Probably ought to check your clock. Your posting from the future. -- Regards, Tom Ogilvy "CLR" wrote in message ... Thanks for the response Tom, but Don already got me there....... Vaya con Dios, Chuck, CABGx3 "Tom Ogilvy" wrote in message ... ? activewindow.Zoom 100 -- Regards, Tom Ogilvy "CLR" wrote in message ... Hi All......... I am doing a routine that runs best with the ActiveWindow.zoom = 100 What I would like, is to be able to determine what the ActiveWindow.Zoom setting actually is prior to running my routine, so I can change it to 100, run the routine, and then change it back to whatever it was.......... Any help would be much appreciated........ Vaya con Dios, Chuck, CABGx3 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWindow size?
I see the differences too, but I don't understand why. My system clock is
right on with official USA time here in Florida....same as my watch and cellphone, and same as www.time.gov Your 4:18 post didn't show up on my computer until about 5:30 my time........and Don's first response showed up as 3:50, which is before I posted the question at 4:32........ Right now my system clock etc etc says 9:08, so we'll see what time this posts as........ Vaya con Dios, Chuck, CABGx3 "Tom Ogilvy" wrote in message ... Probably ought to check your clock. Your posting from the future. -- Regards, Tom Ogilvy "CLR" wrote in message ... Thanks for the response Tom, but Don already got me there....... Vaya con Dios, Chuck, CABGx3 "Tom Ogilvy" wrote in message ... ? activewindow.Zoom 100 -- Regards, Tom Ogilvy "CLR" wrote in message ... Hi All......... I am doing a routine that runs best with the ActiveWindow.zoom = 100 What I would like, is to be able to determine what the ActiveWindow.Zoom setting actually is prior to running my routine, so I can change it to 100, run the routine, and then change it back to whatever it was.......... Any help would be much appreciated........ Vaya con Dios, Chuck, CABGx3 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWindow size?
I read it at 9:23 PM and it showed a posting time of 10:08 PM
-- Regards, Tom Ogilvy "CLR" wrote in message ... I see the differences too, but I don't understand why. My system clock is right on with official USA time here in Florida....same as my watch and cellphone, and same as www.time.gov Your 4:18 post didn't show up on my computer until about 5:30 my time........and Don's first response showed up as 3:50, which is before I posted the question at 4:32........ Right now my system clock etc etc says 9:08, so we'll see what time this posts as........ Vaya con Dios, Chuck, CABGx3 "Tom Ogilvy" wrote in message ... Probably ought to check your clock. Your posting from the future. -- Regards, Tom Ogilvy "CLR" wrote in message ... Thanks for the response Tom, but Don already got me there....... Vaya con Dios, Chuck, CABGx3 "Tom Ogilvy" wrote in message ... ? activewindow.Zoom 100 -- Regards, Tom Ogilvy "CLR" wrote in message ... Hi All......... I am doing a routine that runs best with the ActiveWindow.zoom = 100 What I would like, is to be able to determine what the ActiveWindow.Zoom setting actually is prior to running my routine, so I can change it to 100, run the routine, and then change it back to whatever it was.......... Any help would be much appreciated........ Vaya con Dios, Chuck, CABGx3 |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWindow size?
I am using the msnews.com method and got the posting @ 9:08
Tom's ans 8:25 Chucks' 9:44 Toms 9:22 Nicks 3:33 am it is 7:04 am in Ausin Tx Central DST -- Don Guillett SalesAid Software "CLR" wrote in message ... I see the differences too, but I don't understand why. My system clock is right on with official USA time here in Florida....same as my watch and cellphone, and same as www.time.gov Your 4:18 post didn't show up on my computer until about 5:30 my time........and Don's first response showed up as 3:50, which is before I posted the question at 4:32........ Right now my system clock etc etc says 9:08, so we'll see what time this posts as........ Vaya con Dios, Chuck, CABGx3 "Tom Ogilvy" wrote in message ... Probably ought to check your clock. Your posting from the future. -- Regards, Tom Ogilvy "CLR" wrote in message ... Thanks for the response Tom, but Don already got me there....... Vaya con Dios, Chuck, CABGx3 "Tom Ogilvy" wrote in message ... ? activewindow.Zoom 100 -- Regards, Tom Ogilvy "CLR" wrote in message ... Hi All......... I am doing a routine that runs best with the ActiveWindow.zoom = 100 What I would like, is to be able to determine what the ActiveWindow.Zoom setting actually is prior to running my routine, so I can change it to 100, run the routine, and then change it back to whatever it was.......... Any help would be much appreciated........ Vaya con Dios, Chuck, CABGx3 |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWindow size?
And your timezone is set correct, too?
CLR wrote: I see the differences too, but I don't understand why. My system clock is right on with official USA time here in Florida....same as my watch and cellphone, and same as www.time.gov Your 4:18 post didn't show up on my computer until about 5:30 my time........and Don's first response showed up as 3:50, which is before I posted the question at 4:32........ Right now my system clock etc etc says 9:08, so we'll see what time this posts as........ Vaya con Dios, Chuck, CABGx3 "Tom Ogilvy" wrote in message ... Probably ought to check your clock. Your posting from the future. -- Regards, Tom Ogilvy "CLR" wrote in message ... Thanks for the response Tom, but Don already got me there....... Vaya con Dios, Chuck, CABGx3 "Tom Ogilvy" wrote in message ... ? activewindow.Zoom 100 -- Regards, Tom Ogilvy "CLR" wrote in message ... Hi All......... I am doing a routine that runs best with the ActiveWindow.zoom = 100 What I would like, is to be able to determine what the ActiveWindow.Zoom setting actually is prior to running my routine, so I can change it to 100, run the routine, and then change it back to whatever it was.......... Any help would be much appreciated........ Vaya con Dios, Chuck, CABGx3 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get ActiveWindow | Excel Programming | |||
| Excel.ActiveWindow Is Excel.ActiveWindow Returns False | Excel Programming | |||
| How can I refer to the ActiveWindow | Excel Programming | |||
| ActiveWindow VBA problem | Excel Programming | |||
| Using ActiveWindow.PointsToScreenPixelsY | Excel Programming | |||
Hybrid Mode
