Hide a columon

N

Nikos Antoniadis

Hello,
my question might seem silly.
I want to create a pricelist i have my supplies pricelist and i want to add
a percentage to that prices.Then i want to sent the new pricelist to my
customers. but i don not want them to be able to see the prices i get. I
have added the percentage i want and hide the other column whitch has the
suppliers prices. but anyone can unhide that column! Is there any solution?
And What?
Thank you in advance
Nikos Antoniadis
 
D

Don Guillett

You could put on another sheet that is hidden using VERYhidden in a macro or
even another workbook with a macro that updates the values on the user
workbook.
 
B

Bernard Liengme

You could unlock the cells that customers are expect to change and then
protect the worksheet with a password.
A determined person can break this but not a causal Excel user.
OR
Put the data in another sheet and hide that sheet with VBA VeryHidden code
Here is some sample code
Sub HideunhideSheet()
'hide the sheet from the user cannot see from the
'format...sheet..unhide menu
Sheet1.Visible = xlSheetVeryHidden
'will make the sheet visible again
Sheet1.Visible = xlSheetVisible
End Sub


Or open VBE; use View | Property Window; select the sheet to hide and in the
Property Window set the Visible property to VeryHidden. Not many causal
users would know how to do this!

best wishes
 
I

Ian

Yasou Niko

2 options

1. Hide the column then protect the sheet with a password before sending it.
2. Copy and paste the columns you want to send to a new sheet and send that.

Option 2 is potentially more work in order to obtain the correct layout in
the new sheet, but is safer than option 1 as passwords can be cracked.
 
K

Ken Wright

It doesn't matter how you hide it, if you send it out like that then you may
as well assume you have given away your markups. The ONLY safe way to
distribute your data is to send out a copy of your workbook that has been
hardwired by using past special values.

Excels protection is really only good enough to guard against inadvertant
error.
 
Top