Making a macro "auto open"
in [Word VBA]
|
Prev: Switching between documents and windows
Next: Using InsertFile and Page Numbering 'Restart' behaves unexpectedly
From: JoshMandel on 25 Feb 2010 15:39 Hello, I have the following macro, which lets me set the zoom level for a document to 75%: Sub View75percent() ' ' View75percent Macro ' ' ActiveWindow.ActivePane.View.Zoom.Percentage = 75 End Sub My question is: how can I edit this to make it an "autoopen" macro, so that it will automatically open all existing documents to this zoom level? Many thanks, Josh Mandel
From: christophercbrewster via OfficeKB.com on 25 Feb 2010 17:42 You just call it AutoOpen. You can only have one of these that applies. Same with AutoExec and AutoNew. JoshMandel wrote: >Hello, > >I have the following macro, which lets me set the zoom level for a document >to 75%: > > Sub View75percent() > ' > ' View75percent Macro > ' > ' > ActiveWindow.ActivePane.View.Zoom.Percentage = 75 > End Sub > >My question is: how can I edit this to make it an "autoopen" macro, so that >it will automatically open all existing documents to this zoom level? > >Many thanks, >Josh Mandel -- Christopher Brewster Lockheed Martin, Eagan MN Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/word-programming/201002/1
From: Gordon Bentley-Mix on 25 Feb 2010 17:47 Please don't post the same question in multiple newsgroups; cross-post instead so the answer provided in one newsgroup is displayed in all newsgroups. -- Cheers! Gordon Bentley-Mix "JoshMandel" <JoshMandel(a)discussions.microsoft.com> wrote in message news:5A4AE8AB-B671-411C-861D-5B88F8A61114(a)microsoft.com... > Hello, > > I have the following macro, which lets me set the zoom level for a > document > to 75%: > > Sub View75percent() > ' > ' View75percent Macro > ' > ' > ActiveWindow.ActivePane.View.Zoom.Percentage = 75 > End Sub > > My question is: how can I edit this to make it an "autoopen" macro, so > that > it will automatically open all existing documents to this zoom level? > > Many thanks, > Josh Mandel
From: JoshMandel on 25 Feb 2010 22:32
Thank you, Christopher! And I apologize, Gordon, for the double post -- I didn't realize until later that I should've included this in General questions as well. Josh "christophercbrewster via OfficeKB.com" wrote: > You just call it AutoOpen. You can only have one of these that applies. Same > with AutoExec and AutoNew. > > JoshMandel wrote: > >Hello, > > > >I have the following macro, which lets me set the zoom level for a document > >to 75%: > > > > Sub View75percent() > > ' > > ' View75percent Macro > > ' > > ' > > ActiveWindow.ActivePane.View.Zoom.Percentage = 75 > > End Sub > > > >My question is: how can I edit this to make it an "autoopen" macro, so that > >it will automatically open all existing documents to this zoom level? > > > >Many thanks, > >Josh Mandel > > -- > Christopher Brewster > Lockheed Martin, Eagan MN > > Message posted via OfficeKB.com > http://www.officekb.com/Uwe/Forums.aspx/word-programming/201002/1 > > . > |