Cách bảo vệ thông tin Sheet trong file excel - Ẩn Sheet nâng cao

Nguyễn Xuân Hợp
768 followers
2.4K Video Views·Feb 13, 2025
Cách bảo vệ thông tin Sheet trong file excel - Ẩn Sheet nâng cao
Chào mừng các bạn đã đến với kênh GJW Nguyễn Xuân Hợp. Kênh chia sẽ kiến thức bổ ích về tin học cũng như những video về văn hóa truyền thống. Nếu thấy video có ích đừng ngại bấm like và chia sẽ các bạn nhé. Cảm ơn các bạn rất nhiều.
Welcome to my channel
In this video, I'm going to show you how to protect your files in Excel
As you can see, I have 4 files here
They are information, employee name, email address and address
And I want to hide one file
Any of these 4 files
So that other people can't see
You will have to click the right mouse button and choose to hide
That is, hide this file
But unfortunately, this method is not safe
You can click the right mouse button and choose to hide
So that other people will see the information about the employee name
That you need to hide
To protect this employee name
What will you do?
First, you click the right mouse button
Click the employee name and choose to hide
Then, you click the right mouse button
And choose to hide
That is, hide this file
So that other people can't see
You will have to click the right mouse button
And choose to hide
Then, you click the right mouse button
That is, hide this file
There are 3 parameters
1st, 0th and 2nd
I will explain it like this
1st means to show
0th means not to show
And 2nd means not to show
Special protection
That is, high level protection
I will choose to hide
I will choose the employee name
And I will choose 2
And after you choose to hide
You will click the right mouse button
In this employee name
You will choose to insert
And you choose the module
After choosing the module
You will go to the tool
BPA Proverty
And
After you have entered
BPA Project
Then you will choose
Protection
And you will click
Select when the project has a view
That is
Result
And the bottom part
You put the password
For example, I will put 12345
12345
I will put the password
I will click OK
After that
You will delete
This Visual Basic
And now you will
Go to File
Save as
You will save
Another file
For example, now I will
Save my file name
111311
And you remember the tail
Tail of the mouse
You will choose the Macbook
Mac Pro
And you will click Save
Now I will turn it off
When you have
A file called 111
You just saved
I will turn it on
Now you will
You will want to display the information
You will right-click
And you choose View Code
And now
The software will ask for the password
If you don't have a password
You can never display
Now for example, I will click
Wrong, I will click 12345
The software will tell you
The password is wrong
Now I will click 12345
The password is correct
So the software will
Give you the right to open
To fix
Now you will go
To VBA Project
Then you choose
The number
And you will
Switch from
2 to 1
From 1 to 0
I will
Turn off VBA
When you see
The number is open
So after a few simple steps
You can save
Anything you want
That is sensitive information
You don't want anyone to see
You can use this way
And I hope I have helped you
Now I say goodbye
See you again
