Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change from left-to-right as default setting | Setting up and Configuration of Excel | |||
Change Default Setting-Find & Replace-How? | Excel Discussion (Misc queries) | |||
How to change the default setting for font and size? | Excel Discussion (Misc queries) | |||
How do I change the default setting for an object when I paste? | Excel Discussion (Misc queries) | |||
change the default setting of the line of objects. .75 to 2. | Excel Discussion (Misc queries) |