| Home |
| Search |
| Today's Posts |
|
#1
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 |
|
#2
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 |
|
#3
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 |
|
#5
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 |
|
#6
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 |
|
#7
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 |
|
#8
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 |
|
#9
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 |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWindow size?
I went to goolge and saw:
Newsgroups: microsoft.public.excel.programming From: "CLR" Date: Sat, 24 Mar 2007 21:08:34 -0500 Local: Sat, Mar 24 2007 10:08 pm Subject: ActiveWindow size? I think you have the wrong time zone set on your computer. I am in Virginia so Florida and Virginia should both be in Eastern Daylight time and my offset is -0400 -- Regards, Tom Ogilvy "CLR" wrote in message ... I don't get it.........I just got this off Google and it lines up with my IE5, both saying I posted at 9:08 CLR View profile More options Mar 24, 9:08 pm Newsgroups: microsoft.public.excel.programming From: "CLR" Date: Sat, 24 Mar 2007 21:08:34 -0500 Local: Sat, Mar 24 2007 9:08 pm Subject: ActiveWindow size? Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author 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 ... - Hide quoted text - - Show quoted text - "Tom Ogilvy" wrote in message ... 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 |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWindow size?
I don't get it.........I just got this off Google and it lines up with my
IE5, both saying I posted at 9:08 CLR View profile More options Mar 24, 9:08 pm Newsgroups: microsoft.public.excel.programming From: "CLR" Date: Sat, 24 Mar 2007 21:08:34 -0500 Local: Sat, Mar 24 2007 9:08 pm Subject: ActiveWindow size? Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author 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 ... - Hide quoted text - - Show quoted text - "Tom Ogilvy" wrote in message ... 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 |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWindow size?
Tom
I suspect it is a daylight saving update issue as you guys changed this year. We changed today, I suspect Chuck's machine will catch up on your 'normal' date next week -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Tom Ogilvy" wrote in message ... I went to goolge and saw: Newsgroups: microsoft.public.excel.programming From: "CLR" Date: Sat, 24 Mar 2007 21:08:34 -0500 Local: Sat, Mar 24 2007 10:08 pm Subject: ActiveWindow size? I think you have the wrong time zone set on your computer. I am in Virginia so Florida and Virginia should both be in Eastern Daylight time and my offset is -0400 -- Regards, Tom Ogilvy "CLR" wrote in message ... I don't get it.........I just got this off Google and it lines up with my IE5, both saying I posted at 9:08 CLR View profile More options Mar 24, 9:08 pm Newsgroups: microsoft.public.excel.programming From: "CLR" Date: Sat, 24 Mar 2007 21:08:34 -0500 Local: Sat, Mar 24 2007 9:08 pm Subject: ActiveWindow size? Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author 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 ... - Hide quoted text - - Show quoted text - "Tom Ogilvy" wrote in message ... 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 |
|
#13
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 |
|
#14
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 |
|
#15
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveWindow size?
Time Zone setting is as follows;
(GMT-05:00)Eastern Time (US & Canada) It all looks good from my end........... It's 8:36pm here in St. Petersburg, Florida Don got the same readings I got..... Vaya con Dios, Chuck, CABGx3 "Dave Peterson" wrote in message ... 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 | |||
Linear Mode
