Permenantly Hiding Columns

R

Rockman

I have a 10K row 5 column sheet. One of the columns (D)
is the wholesale costs of my products the (E) column is
retail. I have to email this sheet to a new client and
want to make it so they can not view the wholesale (D)
column. Cant just delete because the formula d2*40%+d2 is
in E and when I delete D the value of E =$-.

Is there a way to hide (D) either by password or with a
macro, Ive never written a macro?

HELP
THANKS
Rockman
 
T

TK

You could hide the column and use password protection on
the workbook structure, but this sounds like a bad idea to
me.

Even if the column cannot be viewed directly by a user
there are many ways that the contents of a hidden column
can be determined by a user. The fact that your formulas
can access the contents of the 'hidden' column should make
this clear. In fact, since your formula reveals that your
price is 140% of wholesale it makes the point of hiding
your cost column kind of moot.

I would recommend that you copy the data in column E and
using the 'Edit/Paste Special' menu option, paste the
calculated values back over the formulas. After doing this
you can delete column D and there won't be any trace of
your costs or pricing formulas in the spreadsheet that you
send to your client.

Hope that helps,

TK
 
R

RagDyer

Make a copy of the sheet.
Select column E.
Right click in the selection and choose "Copy".
Right click again in the selection, and choose "PasteSpecial", and click on
"Values", then <OK>.

You can now delete column D, and the data in column E will remain the same!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a 10K row 5 column sheet. One of the columns (D)
is the wholesale costs of my products the (E) column is
retail. I have to email this sheet to a new client and
want to make it so they can not view the wholesale (D)
column. Cant just delete because the formula d2*40%+d2 is
in E and when I delete D the value of E =$-.

Is there a way to hide (D) either by password or with a
macro, Ive never written a macro?

HELP
THANKS
Rockman
 
U

unlikeKansas

If you absolutely must keep the wholesale costs column: First hide your column You can also hide the formulas. Got to Format|Cells|Protection and then check the Hidden option. As the description says:

"Locking cells or hiding formulas has no effect unless the workbook is protected. To protect the worksheet, Choose Protection from the Tools menu and then Choose Protect Sheet. A password is optional."

On protecting the sheet (with an optional password) bothe the hidden column and the formulas in column E will not be viewable by you new customer.

However I agree with TK that password protection of worksheets is fairly easy to circumvent. There have been several answers on this board that show how it can be done.

unlikeKansas
 
Top