Posted on Leave a comment

Windows button not working after Windows 10 Upgrade

“Open Windows PowerShell as Administrator
Method 1: Press Windows Key + R on your keyboard Key in PowerShell and hit
Enter. Right click on the PowerShell icon on the taskbar and select Run as
Administrator.
Method 2: Right click Start button Choose Command prompt (Admin) Key in
Powershell in the black window and hit Enter. Paste the following command in the
Administrator: Windows PowerShell window and press Enter key:
Get-AppXPackage -AllUsers | Foreach {Add-AppxPackage -DisableDevelopmentMode
-Register “$($_.InstallLocation)\AppXManifest.xml”}
Wait for PowerShell to execute and complete the command. Ignore the few errors
(in red color) that may pop up. When it finishes, try hitting Start and
hopefully it’ll start working.
Posted on Leave a comment

CATEGORY Menu Of TABLEAU Zencart Template Not working

TABLEAU template is great design by Numinix, however there is a bug when you add a new Category, the menu didn’t show up in the Main menu for some reason.

To fix this do the following:

Open the following file from your ZenCart Installation:
Includes/templates/tableau/templates/tpl_modules_categories_tabs.php

Locate the following code (line22 on my clients site)
categories_tab_query = "SELECT c.categories_id, cd.categories_name FROM ".TABLE_CATEGORIES." c, ".TABLE_CATEGORIES_DESCRIPTION . " cd," . TABLE_HIDE_CATEGORIES . " cde WHERE c.categories_id = cd.categories_id AND c.parent_id= '0' AND cd.language_id='" . (int)$_SESSION['languages_id'] . "' AND c.categories_status='1' ORDER BY c.sort_order, cd.categories_name;";
replace it with this
$categories_tab_query = "SELECT c.categories_id, cd.categories_name FROM ".TABLE_CATEGORIES." c, ".TABLE_CATEGORIES_DESCRIPTION . " cd WHERE c.categories_id = cd.categories_id AND c.parent_id= '0' AND cd.language_id='" . (int)$_SESSION['languages_id'] . "' AND c.categories_status='1' ORDER BY c.sort_order, cd.categories_name;";

Posted on Leave a comment

How to unprotect Excel workbook if you don’t have the password

This method only works for Excel in .xlsx format. Hence, if your Excel workbook is in .xls format, just open it and then save it as .xlsx format.
Step 1: Change the Excel file name extension from .xlsx to .zip. Just click on Yes to make sure when prompted.


Step 2: Open the ZIP archive as 7-ZIP. Open the folder xl->worksheets and you can see threesheet.xml files. Select the sheet1.xml file inside the xl>worksheets directory. Right click on it and select Edit. Choose to open it withNotepad.


Step 3: Delete the tag beginning with sheetProtection. Then save and close the sheet1.xml file.

Step 4: Update the modified sheet1.xml file in the ZIP archive when prompted. Then close the ZIP archive.

Step 5: Repeat Step 2 for sheet2.xml, sheet3.xml … for all the sheet that is protected.


Step 6: Change the ZIP fie name extension back to .xlsx. At this point, the Excel sheet has been unprotected. Open it and you can edit the sheet without password.

“With great power comes great responsibility”