Author Archives: tabcom

Disable Windows Authentication (single sign on) in Chrome web browser

  1. Press Windows’ Start button, type “Internet Options” to search, and click the one result, from the control panel
  2. Go to the “Security” tab
  3. Select “Local Intranet” and click on “Custom Level” button

  4. Scroll to the “User Authentication” section at the bottom of the list and select “Prompt for user name and password”
  5. Click Ok, Apply, and Ok to save changes
  6. Close all instances of the IE browser to make the changes effective. Launch the browser again and access the application. A basic authentication challenge will be served.

This applies to both Internet Explorer and Chrome since Chrome uses system settings that are managed using Internet Explorer.

Disable Windows Authentication (single sign on) in Chrome web browser was last modified: September 24th, 2020 by tabcom

Block adblock detection popups

uBlock Origin

  1. Right click the extension icon and then Options. A new tab will open.

  2. You’ll see a few sub-tabs, click on “Filter lists”

  3. Under “Ads”, tick the box that says “Adblock Warning Removal List”

  4. If a warning icon appears beside it, click “Update now” on the top

AdBlock Plus

Options > Advanced > Filter Lists > Adblock Warning Removal List > Active

  • AdGuard

Ad Blocker > Scroll down to add filter > AdBlock Warning Removal List is down under annoyances

  • uBlock

Enable “Adblock Warning Removal List‎” under “3rd party lists”

Block adblock detection popups was last modified: October 13th, 2019 by tabcom

Excel VBA example

 'Select cells and copy
 Range("I2:L14").Select
 Selection.Copy
 
 'Create new sheet and rename
 Sheets.Add After:=ActiveSheet
 ActiveSheet.Name = Format(Now(), "dd-MM-yy hh-mm-ss")
 
 'Paste
 Selection.PasteSpecial Paste:=xlPasteAll
 Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
 Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
 
 'Cleanup
 Sheets(1).Select
 
 Range("E1").ClearContents
 Range("B4:B5").ClearContents

 Range("A1").Select
Excel VBA example was last modified: July 25th, 2018 by tabcom