Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to change default setting on startup
Back in the macro editor go to the ThisWorkbook module. Paste this in:
Sub Workbook_Open() Application.DefaultWebOptions.UpdateLinksOnSave = False End Sub -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "paankadu" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to change default setting on startup
Paankadu -
Set the name of the macro to Auto_Open. Look at the RunAutoMacros method in VBA Help in Excel (help from the code window). -- Daryl S "paankadu" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |