Share this content
0
55778

Excel - prevent hidden columns being seen?

Excel - prevent hidden columns being seen?

How can I give a spreadsheet to another user in a way that prevents them from seeing any hidden (working) columns)?
Mike James

Replies

Please login or register to join the discussion.

30th Aug 2001 02:41

Suggestion to ? - Excel - prevent hidden columns being seen
You can hide column without being seen and restrict them to make changes or editing your spreadsheet by:
1 Hide the columns and/or rows you wish not to be seen by higlithing the column and/or rows, then press the righ click button of your mouse and choose hide.
2 Highlighting the whole sheet by pointing the pointer to the left corner of the spreadsheet between the column heading and the row numbers, then
3 Go to format menu and click the cell. A format cell box will appear, choose protection and click the box opposite the Hidden word. You will notice that a check mark will appear on the box at the same time you will notice to that the locked boxed has a check mark since that is a default system of excel.
4 Press the Tools menu and choose protection then protect sheet - a password will be asked.

Thats All!!!

Remember to protect the shhet without it the formulas and information on the hidden columns can be seen by just unhiding them with the protection menu they cannot edit your file at the same time the file is for viewing purposes only.

I hope this will help you.

Thanks (1)
avatar
By cbales
26th Aug 2001 09:39

Put on a password to modify
Mike
finalise the spreadsheet the way you want it to look then click on "Save as" under the file menu. Click on the "Options" button bottom right of the "save as" window and enter a password in the "Password to modify" box (and keep a note of it for your own use!). I suggest you also click on the "Read only recommended box".
Click on OK and re-enter the password in the confirmation window. Then click on the save button on the main "Save as" screen.
The password to modify request window will then appear each time an attempt to open the workbook is susequently made. The workbook can be opened in read only mode by clicking on the "read only mode" button without the entry of the password and the user will be prevented from unhiding your hidden columns. To modify the workbook, your password will need to be entered into the password window on opening the file.
Users will of course be able to see that you have hidden columns as the column headers will make it rather obvious. You can hide the column headers and row numbers by following "Tool, Options, View tab, Window options" and unchecking the "Row and column headers" box.
Hope this helps.

Thanks (0)
avatar
26th Aug 2001 12:15

Password doesn't stop unhiding columns
Yup, tried that but I can still open the file in read-only and then unhide columns....need something sneakier!
Thank you
Mike
PS I'm using Excel97

Thanks (0)
avatar
26th Aug 2001 14:13

protect the sheet
If you protect a sheet (this can also be password protected) the user cannot unhide any hidden columns. Don't know if this causes more problems than it solves in this case but may be worth looking at.

Thanks (0)
avatar
By cbales
26th Aug 2001 16:38

Mike
You're right and Ruth's suggestion is more relevant.
You could of course change the text/numbers colour in the hidden columns to the same as the sheet background but you would also need to use macros to turn off the formula bar on opening the file and turn it back on again when closing the file. (the check box to turn it on and off is on the tools, options, view tab)
You can also consider using the protection options from the tools menu in conjunction with this. I'm presuming that locking the data in the hidden columns is not an option.
If you've not tried writing macro's, you will find the macro writing tutorial written by James Thorne and myself to be a good solid starting point.

Thanks (0)
avatar
26th Aug 2001 20:20

Protecting the sheet does it!
Thank you all for your comments. I had tested protecting the workbook but not the sheet. This does what I need. Thank you

Thanks (0)
Share this content