LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default Macro to change default setting on startup

I am in need of a macro that can change a default setting in excel and for it
to run on startup


The task is:
Tools
Options
General
Web Options
Files
uncheck Update links on save


Below is the recording of the macro:

With ActiveWorkbook.WebOptions
..RelyOnCSS = True
..OrganizeInFolder = True
..UseLongFileNames = True
..DownloadComponents = False
..RelyOnVML = False
..AllowPNG = False
..ScreenSize = msoScreenSize800x600
..PixelsPerInch = 96
..Encoding = msoEncodingWestern
End With
With Application.DefaultWebOptions
..SaveHiddenData = True
..LoadPictures = True
..UpdateLinksOnSave = False
..CheckIfOfficeIsHTMLEditor = True
..AlwaysSaveInDefaultEncoding = False
..SaveNewWebPagesAsWebArchives = True
End With

End Sub

It is set in a module and I would like it to run on startup. By saving it in
the originial document it will carry over to each version that is saved.

Thanks in advance for your assistance
Angie
--
Thanks,
Angie
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change from left-to-right as default setting Rauf A. Khokhar Setting up and Configuration of Excel 0 June 11th 08 09:48 AM
Change Default Setting-Find & Replace-How? Roy Sprunger Excel Discussion (Misc queries) 7 February 17th 08 06:19 PM
How to change the default setting for font and size? Eric Excel Discussion (Misc queries) 5 May 13th 06 05:12 PM
How do I change the default setting for an object when I paste? MichelleSomers Excel Discussion (Misc queries) 0 March 13th 06 09:33 PM
change the default setting of the line of objects. .75 to 2. Tom Pag Excel Discussion (Misc queries) 0 December 19th 05 06:29 PM


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"