Secrurely Hiding Columns and other areas

craigwojo

Board Regular
Joined
Jan 7, 2005
Messages
218
Hi everyone,

I am looking for a secure way of hiding columns in the spreadsheet from being opened. I have heard that Microsofts Excel is pretty easily cracked to view the columns if needed. I know that anything is able to be cracked if needed. But is there a 3rd party that has something to make it more secure and/or harder to access the hiden material?

Thank you,
Craig
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Joe Was

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
Their are high and low tech things you can do to trip up someone who is doing work-arounds on your security.

Low tech, change the column fonts to the color of the cell backgrounds then hide. Add a Selection Event that make it impossible to select cells in that column [Password protect]. Put data that will be hidden way off to the right of the sheet [most people dont look that far.].

High tech, do all the calculations by VBA code so no formula references are shown in cell that tip the user off that data is in hidden columns. Put that data in hidden columns on their own hidden sheets. Use code to gray out the menue options that would un-hide or deal with security. Then you only need to deal with the password security weaknesses. I have and others have posted code to do these things before.
 

Forum statistics

Threads
1,137,302
Messages
5,680,710
Members
419,929
Latest member
Atlas Quinn

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