VBA for Security to Spreadsheet

neener

New Member
Joined
Aug 22, 2006
Messages
44
Hello everyone:

I have a spreadsheet where all my info and work is on sheet2,called
Transport.What I would like to do if possible would be to first add
a sheet in front of my worksheet,so when anyone opened my spreadsheet
only sheet 1 would show,and on sheet 1 would be a box set up to put a
password into.If they didn't have the right password,sheet 2 would stay
hidden and couldn't get into it.Once the correct password was entered,sheet1
would disappear and sheet 2 called Transport would be up and running.
Is this possible using VBA?

Please help

Thank you all

Neener.
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,813
Office Version
  1. 365
Platform
  1. Windows
Hi
Yes it is possible, but for what you need, a simpler solution would be to save the workbook, and set a password to be required to open it, at the same time, so that each time it's opened, the user's prompted for a password, rather than having to add & hide sheets etc etc.
For this use saveAs/tools/general options.

If you REALLY want what you've asked for, post back and you'll have what you desire.

Bear in mind that pretty much any protection associated with workbooks is fairly easily crackable though.
 

Forum statistics

Threads
1,136,618
Messages
5,676,844
Members
419,655
Latest member
pd2021vb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top