Skip to main content

Hack File .xlsb

For first you must create a backup copy of your Workbook!!!

Then you have to rename the XLSB file with ZIP extension.

Test.XLSB => Test.ZIP            

Opening your ZIP file using a compression software (e.g. WinRar) I can see the content of the file, structured in folders


Inside the folder xl you can find a binary file named vbaProject.bin.
Extract it on your desktop and edit it using a text editor. In my case I used Notepad++.


Using the Find function of your editor, you must search the text DPB


And replace the DPB string with DPx


Then save the vbaProject.bin and replace this file inside the .ZIP File, renaming then .ZIP file in XLSB.

Reopening the XLSB file using Excel, you will get an error message:


you have to answer Yes to this error message. Then Save, Close and Reopen your XLSB file.

Now, if you go to VBA Editor (ALT + F11), you can see and edit all project files.

B. And FIle opened with Alt F11

Add in view code worksheet.
"ActiveSheet.Unprotect "


 Private Sub Worksheet_Activate()
ActiveSheet.Unprotect 
End Sub

Comments

Popular posts from this blog

Menggenerate nomor id

<?php //config $database = "dopo"; $tabel = "po"; $kolom_generate ="id"; $kolom_referensi = "id"; /* Database connection start */ $servername = "localhost"; $username = "root"; $password = ""; $dbname = $database; $mysqli = mysqli_connect($servername, $username, $password, $dbname) or die("Connection failed: " . mysqli_connect_error()); $q1 = "select * from $tabel order by $kolom_referensi DESC"; /* Database connection end */ echo '<table>'; // connect to the database // number of results to show per page $per_page = 10000; // figure out the total pages in the database if ($result = $mysqli->query($q1)) { if ($result->num_rows != 0) { $total_results = $result->num_rows; // ceil() returns the next highest integer value by rounding up value if necessary $total_pages = ceil($total_results / $per_page); // check if the 'page' variab...

CRUD dengan vue.js

pada tutorial kali ini kita akan belajar cara menampilkan data mengunakan  Vue JS  di framework  Codeigniter,  di dutorial sebelumnya kita sudah mempelajari cara Crud mengunakan Vue JS dan Codeigniter, kalian bisa lihat tutorialnya disini  CRUD CODEIGNITER DAN VUE JS  . kali ini kita akan mencoba menampilkan data yang ada pada database dengan framwork codeigniter dan vue js, untuk koneksi database di codeigniter adalah : <?php defined('BASEPATH') OR exit('No direct script access allowed'); $active_group = 'default'; $query_builder = TRUE; $db['default'] = array(     'dsn'    => '',     'hostname' => 'localhost',     'username' => 'root',     'password' => 'root',     'database' => 'civue',     'dbdriver' => 'mysqli',     'dbprefix' => '',     'pconnect' => FALSE,     ...