User Profile
keldsor
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: Word under Windows 11 open links wrong !
It IS ALREADY the case - it shows Skrivebord (danish for Desktop) ! Here is an sample from one of my documents - first I'll show what comes up when you place the mouse on top of a link inserted in the text: and then the NORMAL dialog when editing the link - and it HAS THE RIGHT path to the LOCAL file I want to link to - but the file is opened in the WEB-version of Word: And NOTE it's ONLY under Windows 11 it behaves like this - Windows 10 do it the right way - show in the local or desktop Word ! EDIT: It has to do with the fact that BOTH documents - 1) the one with the inserted link and 2) the one that is linked to - is a copy placed on OneDrive of some documents fra the Cloud. I have tested links between two LOCAL documents - it behaves the right way and opens in local Word. A link from a local document to one on OneDrive (=a copy from the cloud) works right too ! Then there is my situation where the second (the 'linked to'-document opens in WebWord 🤪 Why am I the only one with this problem 😟3Views0likes0CommentsRe: Word under Windows 11 open links wrong !
Now the issue is present again ! I can se that ALL my Word documents with links in them HAVE the link CHANGED to something like "https://d.docs.live.net/.......docx" but I I try to change it - I just open the "normal" dialog showing NOTHING fra the "https://d.docs.live.net/.......docx" !! It seems like links within a Word document is FORCED to "https://d.docs.live.net/.......docx" no matter how the settings are ! But I THINK I had it to work the other day when I MARKED as solution - but it's still here today ... even after re-boot. Something MORE has to be done but WHAT ?16Views0likes2CommentsRe: Default blocking of macros ???
I've now investigated a little more ! I still have this stupid YELLOW line on top og the sheet - but it can be closed with the X-button and then the sheet SEEMS to work BUT... in fact it's the macro referenced in my OnAction for each shape that CAN'T be found ... ALL other macros WILL run. My Excel sheet has a lot of SHAPES users can click and then the OnAction SHOULD start a macro with some parameters from that shape - but the macro can't be found ! What's so special with these "OnAction" for each of my shapes ?4Views0likes0CommentsRe: Default blocking of macros ???
If I add this key to the registry: "AllowTrustedLocationsInNetworkLocations"=dword:00000001 and the reboot - it worked ... but the NEXT time I opened the file I have the same YELLOW message line !!!! You wrote: "Then, after opening the file and enabling content once, it should remember the trust and stop showing the yellow banner unless the file changes or the cache resets again." 1) it CLEARLY don't REMEMBER the trust and stop showing the yellow banner 2) ofcause the file CHANGES ... that's the whole purpose of users opening the file in the first place This security-crap is driving me in sane ... and I think it has to be re-engeeniered a lot more for outsiders to understand 😭 EDIT: I think I have to include the registry I made:7Views0likes0CommentsRe: Default blocking of macros ???
EDIT: SOME macros ARE running - this one: Private Sub Workbook_Open() ' ActiveWindow.DisplayGridlines = False ' Application.DisplayFormulaBar = False ' ActiveWindow.DisplayHeadings = False ' Application.CommandBars.ExecuteMso "HideRibbon" ' Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",FALSE)" With ThisWorkbook nextPNR = .Sheets("NR-Ark").Range("A1") ' dette 2 linier opfattes MÅSKE som en andring af filen ???? rejectOpenWord = .Sheets("NR-Ark").Range("A5") markerObjecter True MsgBox Environ("IDFrandsen"), , "Der køres på disse data:" End With End Sub and after I click OK button a YELLOW line telling me settings for trusted documents are changed and THEN I have the key that leads me to the site I linked to i my last posting.25Views1like4CommentsRe: Default blocking of macros ???
I got a little bit further with your proposals - THX, BUT ... The "DisableMacroBlock.reg" would NOT run by double-clicking - I had to manually add the keys. Too I did the PowerShell-fix ! Still I have a sort of blocking - but of another kind - I was link to this page:31Views0likes5CommentsDefault blocking of macros ???
According to this flowchart: Macros will be enabled IF the document is located in a trusted location ! But it's NOT the case ! I have set my Onedrive as a trusted location and I still have my macros blocked ! My OneDrive have a COPY of a shared folder from other person and this setup WORKS nicely under Windows 10 but NOT under Windows 11 ! It's as though the new default CAN'T be overwritten ! I cant figure out what I have to do from the article where the flowchart is taken from ! What do I have to do more under Windows 11 ?81Views0likes7CommentsWord under Windows 11 open links wrong !
I have a lot of Word dokuments with links to OTHER Word documents. For years I've been editing them in local Word app. and STILL do when runing Word under Windows 10, but when runing Word under Windows11 the links are opened in WebWord ! I HAVE set "dotx" to be opened in local Word in indows settings. What do I mis here ?64Views0likes5CommentsRe: Excel -blocked macros from running becasue the source of this file is untrusted
Oooh man, I'm NOT going to be a doctor in Security Settings - why not JUST tell us what to do to get it to work in Win11 ... it runs nicely in Win10 ! OR ... maybe you HAVE to be a doctor in Security Settings to manage that stupid functionality 🤪329Views0likes0CommentsRe: Excel VBA and starting URL by clicking Shapes ???
I think I found the cause for starting in SafeMode - if you start FireFox (or any other browser, I think) while pressing the SHIFT-key the browser is FORCED to start in SafeMode ... that's my problem ! I have to choose another key to press when I want the users to open the link !4.2KViews0likes0CommentsRe: Excel VBA and starting URL by clicking Shapes ???
???? I don't get you ... I see NO FollowHyperlink in Application ! But I must admit you CAN type it AND compile it without errors, but it wont run - it reports: Run-time error 438 Object doesn't support this property or method It seems like I have to use this - it works like I want to: ActiveWorkbook.FollowHyperlink Sh.Hyperlink.Address & "#" & Sh.Hyperlink.SubAddress UPDATE: No, this last code change didn't do it either - I still get this message with SafeMode or RESET when the browser is NOT running !4KViews0likes1CommentExcel VBA and starting URL by clicking Shapes ???
I have a WorkSheet with a lot of Shapes. Each Shape can be "Loaded" with ScreenTip and a Link by a form accesable by the user by clicking the Shape. My users can enter ScreenTip and URL and edit them too and it works nicely ! The users can too hold SHIFT and CLICK a Shape and then the URL should be shown in the browser and it 'kind of ' work too BUT ONLY when the browser is running beforehand ! If the browser is NOT running a message is presented telling the the browser could be started in SafeMode og RESET - and noe of these alternatives are acccepable. I use this VBA-code: Public Sub retPARInfos(s As String) Dim frm As UserForm, Sh As Shape Set frm = frmRetPARInfos Set Sh = ActiveSheet.Shapes(s) If IsKeyPressed(eksKeyboardShift) Then ' go to the linked address findLinkTilVielsen Sh Else frm.txbInfos = Sh.Hyperlink.ScreenTip frm.txbLinkVielsen = Sh.Hyperlink.Address frmRetPARInfos.Show Sh.Hyperlink.ScreenTip = frm.txbInfos Sh.Hyperlink.Address = frm.txbLinkVielsen End If End Sub Public Sub findLinkTilVielsen(Sh As Shape) If Trim(Sh.Hyperlink.Address) = "" Then visFejlMeddelelse "No link is provided !" Else On Error GoTo notOK Sh.Hyperlink.Follow NewWindow:=True ' Dim Scr_hDC As Long ' Scr_hDC = GetDesktopWindow() ' ShellExecute Scr_hDC, "Open", Trim(Sh.Hyperlink.Address), "", "", 1 GoTo goAhead notOK: On Error GoTo 0 visFejlMeddelelse "Link is corrupt !" goAhead: End If End Sub I have tried another method (commentes out in the code) but is only gives me some of the Address back ??? What do I do wrong here ?Solved4.5KViews0likes5CommentsRe: Dustion: How to turn OFF/ON Ribbon, formular bar etc ect ??
The gridlines works OK - it was the "Formula Bar" that would NOT turn ON again, but moving the setting to the WorkBook_BeforeClose cures the problem. I wont modify any CELLS in this specific WorkBook because it's only build for manipulating SHAPES, so IF my VBA change of SETTINGS is making the woorkbook DIRTY (=has to be saved) then it wood be better to just SAVE without asking. A user woold be conmfused if it asks for SAVING when he has made no changes !3KViews0likes2CommentsRe: Change the connecting point of an arrow head ?
LOL ! I too know that problem way too well ! I think I'll have to work with this 'manual' building of the tree for a while ... just to experience what problems comes up ! MAYBE I can work out an algorythm working very systematically - but time will show ! I think I remember from my math-lectures, it should be possible to make a tree completely flat = no crossing arrows - so I'll try that manually in the first place. In the longer run it would be nice to start that algorythm i MSAccess and then switch to the worksheet in Excel to see the magic building the tree automatically !1.7KViews0likes0CommentsRe: Dustion: How to turn OFF/ON Ribbon, formular bar etc ect ??
HansVogelaar It's too much though - and I think the Application.ExecuteExcel4Macro confuses more than it clears up - so I'll drop that. I now have this code: Private Sub Workbook_Open() markerObjecter ActiveWindow.DisplayGridlines = False Application.DisplayFormulaBar = False ActiveWindow.DisplayHeadings = False ' Application.CommandBars.ExecuteMso "HideRibbon" ' Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",FALSE)" nextPNR = ThisWorkbook.Sheets("NR-Ark").Range("A1") End Sub Private Sub Workbook_Close(Cancel As Boolean) ActiveWindow.DisplayGridlines = True Application.DisplayFormulaBar = True ActiveWindow.DisplayHeadings = True ' Application.CommandBars.ExecuteMso "ShowRibbon" ' Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",True)" End Sub But still there is problem with the Formula bar - it turns OFF but not ON again ! AND When closing the file it asks for SAVE or NOT - eventhough I did NOT change anything ! Is there a cure for that ?3KViews0likes4CommentsDustion: How to turn OFF/ON Ribbon, formular bar etc ect ??
I have a WorkBook where I want the users to have as mush space on the screen as possible - they shall manipulate different kinds of shapes. When finished working that WorkBook I want to set Excel back to 'normalø again for working in other ordinairy workbooks. I therefore build this code in the WorkBook: Option Explicit Option Base 1 Private Sub Workbook_Close(Cancel As Boolean) Application.DisplayGridlines = True Application.DisplayFormulaBar = True ActiveWindow.DisplayHeadings = True ' Application.CommandBars.ExecuteMso "ShowRibbon" ' DoCmd.ShowToolbar "Ribbon", acToolbarYes End Sub Private Sub Workbook_Open() markerObjecter ' Application.DisplayGridlines = False ActiveWindow.DisplayGridlines = False Application.DisplayFormulaBar = False ActiveWindow.DisplayHeadings = False 'Application.CommandBars.ExecuteMso "HideRibbon" 'DoCmd.ShowToolbar "Ribbon", acToolbarNo nextPNR = ThisWorkbook.Sheets("NR-Ark").Range("A1") ' rejectOpenWord = ThisWorkbook.Sheets("NR-Ark").Range("A5") End Sub but I doesn't work, so I commented out the problematic lines (the rejactOpenWord is for other use som just forget that line) What do I do wrong here and how can I fix it ?Solved3.2KViews0likes6Comments
Recent Blog Articles
No content to show