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.

Having problems with installing anything. E: Sub-process /usr/bin/dpkg returned an error code (2)

I get dpkg: unrecoverable fatal error, aborting: files list file for package ‘libjpeg62-turbo-dev:amd64’ is missing final newline E: Sub-process /usr/bin/dpkg returned an error code (2)

I have tried upgrading dist but that requires an installing and i get the same error every time. I can’t install anything. Thanks again for all of your help.

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2746

I’m running an Ubuntu 18.10 machine and I’ve been following this tutorial: https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-2017 I’ve been successful until I got to Connect locally section.

Every time I try this command sqlcmd -S localhost -U SA -P password I get error from the title along with: Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Client unable to establish connection. (it doesn’t matter if I enter right or wrong password it’s always the same error).

I’ve discovered that the problem is with -S localhost part (I also tried entering “(local)”, 127.0.0.1 and . and got same error every time), but I just can’t get it to work. I’ve been searching for solution since yesterday and everything I found didn’t work for me, so I’m putting all my hopes into this question. Thanks in advance!

EDIT: I tried entering the command above without -S localhost and it still throws same error…

EDIT 2: Tried the most upvoted solution from here AND IT WORKED!!! https://stackoverflow.com/questions/57265913/error-tcp-provider-error-code-0x2746-during-the-sql-setup-in-linux-through-te

CordovaError: Promise rejected with non-error: ‘Error code 65 for command

Tengo el siguiente problema al realizar un release en ios con el siguiente comando: ionic cordova build –minifyjs –release

Me arroja el siguiente error:

The following build commands failed:     ProcessProductPackaging "" /Users/milton/Library/Developer/Xcode/DerivedData/Coink-cdqcnaiibmlvbzgblljmcuobajtk/Build/Intermediates.noindex/Pods.build/Release-iphonesimulator/MGSwipeTableCell.build/MGSwipeTableCell.framework-Simulated.xcent     ProcessProductPackaging "" /Users/milton/Library/Developer/Xcode/DerivedData/Coink-cdqcnaiibmlvbzgblljmcuobajtk/Build/Intermediates.noindex/Pods.build/Release-iphonesimulator/Kingfisher.build/Kingfisher.framework-Simulated.xcent     (2 failures)     CordovaError: Promise rejected with non-error: 'Error code 65 for command: xcodebuild with args: -xcconfig,/Users/milton/Documents/Hector/app-clientes-ios-ionic/platforms/ios/cordova/build-release.xcconfig,-workspace,Coink.xcworkspace,-scheme,Coink,-configuration,Release,-sdk,iphonesimulator,-destination,platform=iOS Simulator,name=iPhone Xʀ,build,CONFIGURATION_BUILD_DIR=/Users/milton/Documents/Hector/app-clientes-ios-ionic/platforms/ios/build/emulator,SHARED_PRECOMPS_DIR=/Users/milton/Documents/Hector/app-clientes-ios-ionic/platforms/ios/build/sharedpch' at cli.catch.err (/Users/milton/Documents/Hector/app-clientes-ios-ionic/node_modules/cordova/bin/cordova:30:15) at process._tickCallback (internal/process/next_tick.js:68:7)     [ERROR] An error occurred while running subprocess cordova.      cordova build ios --release exited with exit code 1.      Re-running this command with the --verbose flag may provide more information. 

Por qué puede ocurrir este problema. Al realizar el build por xcode 10 con el sistema legacy funciona perfecto.

Is there a WP plug-in that accepts a referral code at checkout without discounting a product? And a Map Locator in real-time?

Good day! I need your expertise before I make a purchase on plugins. I need TWO plugins that will accomplish these two objectives: 1.) E-commerce that will ALLOW a special code (like a coupon code BUT WON’T discount the product.) We need to track where it came from. We have affiliate stores that direct people to buy straight from us on our own website. We want to give commission to the affiliate store that referred our product etc. and needs to respectfully track it with the utmost integrity. This code represents their store the referral was made. AND 2.) We need a store locator map on our website exactly how it appears here: https://www.acehardware.com/store-locator. Thank you, anyone, for your help. The tech gurus with my hosting company referred me here.

camera stays busy after stopping code

I installed spyder2.X. with Ubuntu 16.04, gave me this message:

Spyder crashed during last session.          ........         ....... 

then, installed it by:

sudo pip install -U spyder 

this commend installed spyder3

the problem:

when running the code from spyder, the camera stays busy after stopping running.

when running the code from the terminal, everything is ok.

I read more about this problem, one comment is very hard https://github.com/spyder-ide/spyder/issues/3554 “Closing because this is a Debian/Ubuntu problem because they decided to intentionally break Spyder.”

Also, this enter link description here change OpenCV version but my case is different. my case with spyder, not OpenCV.

the summary:

I can’t use an anaconda library and python3 because of some confliction with ROS library.

please help me or any suggestion

Thank you in advance!