Sub activewindowzoom()
oldzoom = ActiveWindow.Zoom
' MsgBox oldzoom
ActiveWindow.Zoom = 100
MsgBox "hi there"
ActiveWindow.Zoom = oldzoom
End Sub

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"CLR" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>
>
>
>

? activewindow.Zoom
100



--
Regards,
Tom Ogilvy


"CLR" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>
>
>
>

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

Glad for the opportunity to be of service to you Chuck

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"CLR" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Thanks Don, that does it nicely for me.
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Don Guillett" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Sub activewindowzoom()
>> oldzoom = ActiveWindow.Zoom
>> ' MsgBox oldzoom
>> ActiveWindow.Zoom = 100
>> MsgBox "hi there"
>> ActiveWindow.Zoom = oldzoom
>> End Sub
>>
>> --
>> Don Guillett
>> SalesAid Software
>> (E-Mail Removed)
>> "CLR" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>> > 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
>> >
>> >
>> >
>> >
>>
>>
>
>

Probably ought to check your clock. Your posting from the future.

--
Regards,
Tom Ogilvy


"CLR" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks for the response Tom, but Don already got me there.......
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Tom Ogilvy" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> ? activewindow.Zoom
>> 100
>>
>>
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>>
>> "CLR" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>> > 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
>> >
>> >
>> >
>> >
>>
>>
>
>

Thanks Don, that does it nicely for me.

Vaya con Dios,
Chuck, CABGx3


"Don Guillett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Sub activewindowzoom()
> oldzoom = ActiveWindow.Zoom
> ' MsgBox oldzoom
> ActiveWindow.Zoom = 100
> MsgBox "hi there"
> ActiveWindow.Zoom = oldzoom
> End Sub
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "CLR" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > 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
> >
> >
> >
> >
>
>

Thanks for the response Tom, but Don already got me there.......

Vaya con Dios,
Chuck, CABGx3


"Tom Ogilvy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> ? activewindow.Zoom
> 100
>
>
>
> --
> Regards,
> Tom Ogilvy
>
>
> "CLR" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > 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
> >
> >
> >
> >
>
>

I read it at 9:23 PM and it showed a posting time of 10:08 PM

--
Regards,
Tom Ogilvy


"CLR" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>
>> Probably ought to check your clock. Your posting from the future.
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>>
>> "CLR" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > Thanks for the response Tom, but Don already got me there.......
>> >
>> > Vaya con Dios,
>> > Chuck, CABGx3
>> >
>> >
>> > "Tom Ogilvy" <(E-Mail Removed)> wrote in message
>> > news:(E-Mail Removed)...
>> >> ? activewindow.Zoom
>> >> 100
>> >>
>> >>
>> >>
>> >> --
>> >> Regards,
>> >> Tom Ogilvy
>> >>
>> >>
>> >> "CLR" <(E-Mail Removed)> wrote in message
>> >> news:%(E-Mail Removed)...
>> >> > 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
>> >> >
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Probably ought to check your clock. Your posting from the future.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "CLR" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Thanks for the response Tom, but Don already got me there.......
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> > "Tom Ogilvy" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> >> ? activewindow.Zoom
> >> 100
> >>
> >>
> >>
> >> --
> >> Regards,
> >> Tom Ogilvy
> >>
> >>
> >> "CLR" <(E-Mail Removed)> wrote in message
> >> news:%(E-Mail Removed)...
> >> > 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
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>
>

I went to goolge and saw:

Newsgroups: microsoft.public.excel.programming
From: "CLR" <crobe...@tampabay.rr.com>
Date: Sat, 24 Mar 2007 21:08:34 -0500
Local: Sat, Mar 24 2007 10:08 pm
Subject: Re: 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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" <crobe...@tampabay.rr.com>
> Date: Sat, 24 Mar 2007 21:08:34 -0500
> Local: Sat, Mar 24 2007 9:08 pm
> Subject: Re: 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" <twogi...@msn.com> wrote in message
>
>
> news:(E-Mail Removed)...
>
>
> - Hide quoted text -
> - Show quoted text -
>
>
> "Tom Ogilvy" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> I read it at 9:23 PM and it showed a posting time of 10:08 PM
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>>
>> "CLR" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> >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" <(E-Mail Removed)> wrote in message
>> > news:(E-Mail Removed)...
>> >>
>> >> Probably ought to check your clock. Your posting from the future.
>> >>
>> >> --
>> >> Regards,
>> >> Tom Ogilvy
>> >>
>> >>
>> >> "CLR" <(E-Mail Removed)> wrote in message
>> >> news:(E-Mail Removed)...
>> >> > Thanks for the response Tom, but Don already got me there.......
>> >> >
>> >> > Vaya con Dios,
>> >> > Chuck, CABGx3
>> >> >
>> >> >
>> >> > "Tom Ogilvy" <(E-Mail Removed)> wrote in message
>> >> > news:(E-Mail Removed)...
>> >> >> ? activewindow.Zoom
>> >> >> 100
>> >> >>
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Regards,
>> >> >> Tom Ogilvy
>> >> >>
>> >> >>
>> >> >> "CLR" <(E-Mail Removed)> wrote in message
>> >> >> news:%(E-Mail Removed)...
>> >> >> > 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
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>