Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIDE COLUMNS
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIDE COLUMNS
Maybe...
XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns http://support.microsoft.com/default...b;en-ca;211769 Remember to look for comments and merged cells. HIDE COLUMNS wrote: 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. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIDE COLUMNS
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..... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIDE COLUMNS
In article , ?B?Sm9obm55?= wrote:
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..... Remember also ... XL is not secure. The only way to keep data secure is not to put it into sheets that you give others. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide/Unhide columns using button on top over relevant columns | Excel Discussion (Misc queries) | |||
Hide Columns | Excel Worksheet Functions | |||
Hide columns | Excel Discussion (Misc queries) | |||
Hide columns | Excel Discussion (Misc queries) | |||
Cannot Hide Columns | Excel Discussion (Misc queries) |