|How to Protect/Unprotect Multiple Worksheets At Once in Excel|
|If you have a workbook contains multiple protected worksheets with the same password, and now you need to unprotect them for modifying some information. Maybe, you can unprotect the sheets one by one with Unprotect Sheet in Excel, but this will waste a lot of time when there are multiple sheets need to be unprotected. Here, I will introduce you some quick ways to unprotect multiple protected sheets.|
Microsoft Excel • Vba Script
|Slowly hide success and error message divs and remove the query string from the URL|
|When you display content based on the presence of a URL query string value. For example|
"http://website.com/page.html&smsg=You saved successfully"
will display the message, fade out after X seconds (2.5 seconds below) and then remove the query string from the address bar to display just this
|Mask email addresses from web-bots via jQuery|
HTML • JQuery
|Bootstrap 4 responsive tables won't take up 100% width|
|As soon as you apply the .table-responsive class to a table, the table shrinks horizontally and no longer takes up 100% of the width.|
Bootstrap 4 • HTML
|Simple breakpoint viewer for Bootstrap 4|
|Just a convenient multi-colored block to assist while performing your layouts.|
|Creating a modal window with HTML5 & CSS3|
|Modal boxes are a frequently utilized tool in the web developer’s arsenal. Used for, amongst many things, login/register forms; advertisements; or just notifications to the user.|
This doesn’t need to be a problem, because HTML5 & CSS3 allow us to create modal windows with ease.
What we are going to do is use CSS3’s transition, opacity, pointer-event, and background gradient properties to create a very beautiful and functional modal box.
CSS • HTML • Lotus Formula
|Unfortunately, you cannot place multiple onload events on a single page. You can nest multiple functions within the one onload call, but what if you need to cascade an onload script across multiple pages, some which may already have an existing onload event? use the addLoadEvent function below.|
|Calculate time difference crossing midnight|
|This formula will help you calculate the hours difference between two times, even when the end time crosses midnight (Ex 7pm - 2am)|
|A true @Unique|
|@Unique is case-sensitive, so "pear" and "Pear" and "PEAR" in a list will remain as three separate values. The formula below will truly return one value "Pear".|
|Forcing immediate indexes to actually update immediately|
|Have you found that your database's full-text index doesn't update immediately when you save a document, even when the frequency setting is set to "IMMEDIATE"?|
The UPDATE function on the server checks the queue every 5 seconds for new task requests, however it uses the "Update Suppression Time" setting to wait until multiple, similar requests get deposited in the queue before it runs. This can take up to 15 minutes to execute.
Decreasing the suppression time interval on the server isn't a good solution since it will exponentially increase the load on the server's resources. And it still doesn't solve your problem because even a minute delay could frustrate a web user when their new document doesn't show up in search. So instead, the solution below will fire off the UPDALL routine directly in the server console for the specific database.
|Reserved fields for Lotus Domino web applications|
|There are several reserved fields available.|
Lotus Notes Form
|Force Ejecting a Disk - Mac|
|In the event that a disk has become stuck in your Apple computer, there are several steps you can take to try to force it to eject.|
|Stack of Paper|
|Simple, clean effect that works everywhere.|
CSS • HTML
|Convert a string from ISO-8859-1 to UTF-8|
|Use this handy LotusScript function to convert a string from ISO-8859-1 to UFT-8.|
Appcelerator • Appcelerator Alloy • LotusScript • XML
|You can perform specific word/sentence lookups against Google Translate via the AJAX the function below.|
|Force the simulator to use a specific language when performing a test run of your app.|
|You can override the i18n 639-1 locale code so you can test your international apps.|
|How to Solve Dropbox Problems Syncing|
|This problem was caused by a conflict in Dropbox’s cache. Because a file with the same basic name and properties already existed, Dropbox wasn’t able to create the new file on our end. This isn’t always a problem, but it can be if the sun and moon are aligned in a certain way.|
Either way, you can solve these issues almost every time by clearing Dropbox’s hidden cache folder. This folder holds gigabytes of miscellaneous data collected during file downloads and sync processes in a series of smaller files with crazy alphanumeric names. This folder should reset itself every three days, though in cases where your Dropbox application is experiencing a conflict, you may not want to wait for the problem to resolve itself.
Linux • Mac • Windows