ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   hidden columns and row (https://www.excelbanter.com/excel-programming/321029-hidden-columns-row.html)

Laurent M

hidden columns and row
 
My Excel application needs to be secure and i need to hide the first column
and the first row of my sheet.
More over, i would like to lock them.

How can i do that?

Thanks

Don Guillett[_4_]

hidden columns and row
 
Just hide the columns and protect the sheet. Add a password if desired. It
can be easily broken

--
Don Guillett
SalesAid Software

"Laurent M" wrote in message
...
My Excel application needs to be secure and i need to hide the first

column
and the first row of my sheet.
More over, i would like to lock them.

How can i do that?

Thanks




gocush[_29_]

hidden columns and row
 
Laurent,
Security with Excel is very relative: all passwords (for sheets, workbooks,
and vba code can easily be broken.) If you simply want to hide something
from a casual user ok, but don't think it is secure from an advanced user.

To Hide a column or row: select the column by clicking on the Letter at the
top or the Row number at the far left. Then click on the menu item:
formatRowHide or ColumnHide

For protection: Hold down the Alt Key and press TPP

"Laurent M" wrote:

My Excel application needs to be secure and i need to hide the first column
and the first row of my sheet.
More over, i would like to lock them.

How can i do that?

Thanks



All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com