VBA code to notify a user that an Excel document has already been checked out if they attempt to edit it

I have a working, macro enabled Excel sheet on a SharePoint site for about 20 people to all use. I have it set so that it requires to be checked out in order to edit (So that only one person can edit at a time).

This has been working great, except some users of this file either ALWAYS forget to check the “check out and edit” option rather than “read only.” So they will make changes in “Read Only” mode, and end up saving a copy of it on their own computers (because it wasn’t checked out).

I was wondering if it were possible to make some sort of VBA event that checks to see if the document has been checked out of SharePoint before any changes are made, and if it hasn’t, it shows a message box telling them so that they may close it out and re-open in “checked out” mode.

The Web site address “/sites/T3W-PM/010101140819” is already in use

I’ve created a workflow to automate the subsite creation process as much as possible. This has worked perfectly for several day, however. I came in this morning and found that every requested site is returning the following error:

The Web site address "/sites/T3W-PM/010101140819" is already in use. 

It is not possible for the addresses to be in use as the address incorporates a unique project number which is generated at site creation and cannot be repeated.

I have checked the subsites list and the error-ed site do NOT appear to be there. I have also checked the workflow and there is no recursion, that I can identify, which might cause the HTTP call to fire twice.

Blackbox decrypt already encrypted files in case of key loss [on hold]

I have files encrypted data in my git repo but lost my blackbox gpg keys .Is there anyway I can recover these files or decrypt them again.I have generated new keys and executed blackbox_update_all files and blackbox_update but when I try to decrypt them again with blackbox_decrypt_all_files.It is giving me “pg: decryption failed: No secret key” and Unfortunately there is no other blackbox_admin of git repo.

Item (Magento\Catalog\Model\Product\Interceptor) with the same ID already exists

Magento 2.3.2

Item (Magento\Catalog\Model\Product\Interceptor) with the same ID “48” already exists.

I’ve checked all the advice where people have had this issue and nothing helps. There do not appear to be any duplicates in the database, not in urls, not in stock, no multiple website IDs, nothing.

I can fix it by removing the affected products from all categories. Weirdly if I go into the category and remove the product this does not help, only if you go into the product and remove it from all categories.

I’ve reverted to the blank theme and disabled custom extensions.

Magento 2.1: setup:di:compile error Constant MASK_FOR_HIDDEN_FIELDS already defined

When we run the setup:di:compile command we are seeing the following error. I would like to know what is going on here before I contact the extension developer.

I have searched for “MASK_FOR_HIDDEN” in all files and it only exists in the file in the below error and also in one other file. Is this the problem? Do they need to be unique in both files?

[Exception] Notice: Constant MASK_FOR_HIDDEN_FIELDS already defined in /home/signedge/p ublic_html/idcardsolutions.net/app/code/Magenest/SagePay/lib/classes/Sagepa yUtil.php on line 4


Mage registry key already exist error “_singleton/plumbase/feed”

> https://www.activaboualaa.com/errors/report.php?id=414409631915&skin=default


There has been an error processing your request Mage registry key “_singleton/plumbase/feed” already exists


#0 /home/activ/public_html/app/Mage.php(225): Mage::throwException('Mage registry k...') #1 /home/activ/public_html/app/Mage.php(479): Mage::register('_singleton/plum...', false) #2 /home/activ/public_html/includes/src/__default.php(22325): Mage::getSingleton('plumbase/feed') #3 /home/activ/public_html/app/Mage.php(450): Mage_Core_Model_App->dispatchEvent('controller_acti...', Array) #4 /home/activ/public_html/includes/src/__default.php(14225): Mage::dispatchEvent('controller_acti...', Array) #5 /home/activ/public_html/includes/src/Mage_Adminhtml_Controller_Action.php(167): Mage_Core_Controller_Varien_Action->preDispatch() #6 /home/activ/public_html/includes/src/__default.php(14116): Mage_Adminhtml_Controller_Action->preDispatch() #7 /home/activ/public_html/includes/src/__default.php(18849): Mage_Core_Controller_Varien_Action->dispatch('login') #8 /home/activ/public_html/includes/src/__default.php(18379): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #9 /home/activ/public_html/includes/src/__default.php(21354): Mage_Core_Controller_Varien_Front->dispatch() #10 /home/activ/public_html/app/Mage.php(686): Mage_Core_Model_App->run(Array) #11 /home/activ/public_html/index.php(82): Mage::run('', 'store') #12 {main}