Is there a way to display the Startup Prompt dialog from VBA?
Startup Prompt.jpg
The following shows the Edit Links dialog, but I am looking to immediately jump to the options:
Please Login or Register to view this content.
Is there a way to display the Startup Prompt dialog from VBA?
Startup Prompt.jpg
The following shows the Edit Links dialog, but I am looking to immediately jump to the options:
Please Login or Register to view this content.
1. Let users choose ...
2. Don't display ... don't update automatic linksPlease Login or Register to view this content.
3. Don't display ... update linksPlease Login or Register to view this content.
See also the "UpdateLinks" property in the vba context help.Please Login or Register to view this content.
Thank you for taking the time to post that response, however, it has nothing to do with the question asked.
Again, I am looking for a VBA solution to display the Startup Prompt dialog.
I don't think so directly (not that exact screen whilst using only VBA), since pulling up the edit links dialogue will stop your VBA.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
Its simple enough to make a simple form that mimics the built-in, but just don't like reinventing the wheel unnecessarily. I'm surprised at how much I don't know and was hoping someone knew a trick to bring it up, but due to the lack of responses, I'll assume in this case its simpler to just build a form.
yeah,
I imagine you want a handle to pull up that screen without also pulling up the edit links dialogue first. Which might exist but clearly those that have seen this thread don't know of it.
Otherwise you'd have to do something like writing a script and calling it from the last line of the VBA which seems to be complicated enough to defeat your purpose.
If so, then you must use:
1. ActiveWorkbook.UpdateLinks = xlUpdateLinksUserSetting
2. ActiveWorkbook.UpdateLinks = xlUpdateLinksNever
3. ActiveWorkbook.UpdateLinks = xlUpdateLinksAlways
Ps.:
a) Not all internal dialogs box work despite the definition of a suitable constant in excel vba.
b) See "Built-in Dialog Box Argument Lists" in the vba context help and "XlBuiltInDialog" in F2 ("Object Browser") in vba editor.
c) Check the dialog boxes available in your excel using "Application.Dialogs.Count" (only here you have to be a little patient, there are about 800 of these "windows").
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks