I have pricing data for multiple columns, I hide some of the columns so the
multipliers are hidden and send the spreadsheet to co-workers so they can
have a price sheet after the markup. The problem I have is they can un-hide
the columns revealing the hidden data and they can also click on individual
cells and see my private formulas is there a way to e-mail people my
spreadsheet but not allow them to see the hidden columns or the formulas in
individual cells? HELP

You can protect your worksheet by going to Tools Protection and choosing
your options.

" wrote:

I have pricing data for multiple columns, I hide some of the columns so the
multipliers are hidden and send the spreadsheet to co-workers so they can
have a price sheet after the markup. The problem I have is they can un-hide
the columns revealing the hidden data and they can also click on individual
cells and see my private formulas is there a way to e-mail people my
spreadsheet but not allow them to see the hidden columns or the formulas in
individual cells? HELP

protection that can be easily removed
http://www.mcgimpsey.com/excel/removepwords.html

Also, let's say column C is hidden. Select Columns B through D and
copy/paste to a new worksheet. The hidden data is now visible on the
unprotected sheet.

If the coworkers just need the final numbers, you could copy/paste special
values to a new workbook and send them that.

"Melissa" wrote:

You can protect your worksheet by going to Tools Protection and choosing
your options.

" wrote:

I have pricing data for multiple columns, I hide some of the columns so the
multipliers are hidden and send the spreadsheet to co-workers so they can
have a price sheet after the markup. The problem I have is they can un-hide
the columns revealing the hidden data and they can also click on individual
cells and see my private formulas is there a way to e-mail people my
spreadsheet but not allow them to see the hidden columns or the formulas in
individual cells? HELP

I email the worksheet as my email and not as an attachment. The formula and
hidden cells are not shown at all.
--
Mary-Anne in Durban


"JMB" wrote:

protection that can be easily removed
http://www.mcgimpsey.com/excel/removepwords.html

Also, let's say column C is hidden. Select Columns B through D and
copy/paste to a new worksheet. The hidden data is now visible on the
unprotected sheet.

If the coworkers just need the final numbers, you could copy/paste special
values to a new workbook and send them that.

"Melissa" wrote:

You can protect your worksheet by going to Tools Protection and choosing
your options.

" wrote:

I have pricing data for multiple columns, I hide some of the columns so the
multipliers are hidden and send the spreadsheet to co-workers so they can
have a price sheet after the markup. The problem I have is they can un-hide
the columns revealing the hidden data and they can also click on individual
cells and see my private formulas is there a way to e-mail people my
spreadsheet but not allow them to see the hidden columns or the formulas in
individual cells? HELP