HIDE COLUMNS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I cannot hide columns in a certain work book.It is password
protected.Whenever I tried, there was a message CANNOT SHIFT OBJECT OFF
SHEETS.
 
Sort of got a similar question. I would like to hide certain columns within a
spreadsheet as they contain information I would rather not share with others
and password protect it for myself for viewing. I have managed to do this by
creating another sheet and password protecting that copying the information
from the viewable sheet and adding the sensitive columns within the protected
sheet.but it increases the size of the workbook dramatically and seems
inefficient. Any help will be appreciated.....
 
Sort of got a similar question. I would like to hide certain columns within a
spreadsheet as they contain information I would rather not share with others
and password protect it for myself for viewing. I have managed to do this by
creating another sheet and password protecting that copying the information
from the viewable sheet and adding the sensitive columns within the protected
sheet.but it increases the size of the workbook dramatically and seems
inefficient. Any help will be appreciated.....
Click to expand...

Remember also ... XL is not secure. The only way to keep data secure is not
to put it into sheets that you give others. :)
 
Back
Top