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

Post a Comment

Popular posts from this blog

FPDF dengan CodeIgniter

Cetak Surat Keputusan Controller: <?php //File in controller named surat_keputusan.php defined('BASEPATH') OR exit('No direct script access allowed'); class Cetak_surat_keputusan extends CI_Controller { public function __construct()     {         parent::__construct();         $this->load->helper('url');         $this->load->database();                $this->db->select();         $this->db->from('surat.config_sk');                $query = $this->db->get();                 return $query->result();             } public function index() {         if(isset($_GET['id_sk'])){                     date_default_timezone_set('Asia/Jakarta');                         $query=$this->load->database('surat',TRUE)->get_where('config_sk',array('id_sk'=>$_GET['id_sk']));             $data_sk=array(                 'id_sk'=>'',                 'sk_nomo
1 comment
Read more

aktifkan SSH

Cara mengaktifkan SSH di Windows 10   December 19, 2017     Jaringan ,  Keamanan ,  SSH ,  Windows Dulu ketika kita ingin meremote server linux menggunakan aplikasi SSH dari sistem operasi Windows, kita harus menggunakan aplikasi pihak ketiga seperti PuTTY. Sekarang setelah ada update terbaru, sistem operasi Windows 10 sudah memiliki aplikasi SSH. SSH? ya anda tidak salah baca, Windows sekarang sudah memiliki aplikasi SSH (client dan server) sendiri, bukan pihak ketiga. Berikut beberapa tutorial SSH yang pernah saya tulis sebelumnya: cara remote login ke ubuntu server dengan SSH cara memperbaiki failed remote host identification file transfer menggunakan aplikasi SSH dan MC cara remote login dengan ssh tanpa password cara membatasi hak akses login melalui SSH di Ubuntu Server fungsi remote host identification di SSH   mengaktifkan user root pada remote login SSH Lalu bagaimana cara mengaktifkan aplikasi built in SSH di windows 10? Anda harus melakukan upda
Post a Comment
Read more