trust

Hello all, *Second time posting as the last thread did not display correctly* This may be a long shot but I am throwing this out there to see if anyone can help. I would like to recreate a form of a three-structure in Excel. Below is an sample set of folder structure data. Commercial...

I was writing a program and got hung in a loop, so I ended Excel through Task Manager and now I'm getting the message "Because of your security setting, macros have been disabled." I tried going into the Trust Center to re-enable macros, but all the options are greyed out and I can't select...

Nor simple data spreadsheets - so neither xlsx or xlsm These were working fine until yesterday. I can create new programmes. I have reinstalled 365 twice - and tried repairing - when it reinstalled itself again. I have checked that Trust settings appear ok. Suggestions, please, to maintain my...

To save time, lets just assume the Microsoft Trust Prompt after opening a hyperlink will open regardless of trust center settings. I tried automating the prompt with something simple like: Application.Wait (Now + TimeValue("00:00:05")) Application.SendKeys ("{LEFT}")...

Any advice appreciated. I've finally gotten passable at VBA/Excel but this issue is weird and when I search I just find articles on how to enable when I want to disable. I have a report that I edit for a company that is not on my network. I recently started having an issue because after making...

Using Excel 2016, I have a macro that works well if the data is in the pivot table, but if not, it throws an error (Run-Time error '1004': Unable to get the PivotItems proery of the PivotField class). It is try to deselect the District Bank and Regional Trust but they may or may not not appear...

I have the following code that should copy a macro in the current workbook to another workbook I just created from VBA code. Const MODULE_NAME As String = "ShowE" ' Name of the module to transfer Const TEMPFILE As String = "c:\Modul.bas" ' temp textfile Rem ** export the...