Excel problem? 1

[Gazmysta]

Hi all!

Im trying to hide some columbs in excel that i dont want a client to see but once ive hid the columbs if i then send the spreadsheet wont he just be able to highlight the columbs and unhide them? Is there anyway i can hide them without him being able to unhide them or is there another way i can solve my problem? Thank You!

Gazmysta Win XP, Office XP, Pentium 4 2.4Gb, 512 Ram, 37 Gb HD.

 

[xlbo]

Protect the sheet

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[Gazmysta]

Could you tell me how to protect the sheet?

Gazmysta

 

[Gazmysta]

Its ok ive found it, thanks for the help xlbo!!

 

[xlbo]

Tools>Protecttion>Protect sheet. They won't be able to unhide the columns. Depending on version, there are also a number of options that you can allow the user to perform on a protected sheet.....XP has far more than any other version.

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244