I have a worksheet that has many cells/formulas protected so that the data
stays accurate. I left certain cells unprotected for others to access and
fill in their information. The problem is that when trying to send the
worksheet as the message body only, not an attachment, an error pops up
saying--

"A sheet in the workbook you are trying to save is password protected.
Password protected sheets cannot be saved in a Web Page. To save this file
as a Web Page, you must first remove the password."

I would prefer not to have to send the workbook as an attachment, but am at
a loss for how to keep certain cells protected and be able to send as the
message body. Any suggestions?


Thank you--
Bambi

How about not sending as a web page?

Why not just send it as an attachment (keeping it an excel workbook)?

Bambi Williams wrote:

I have a worksheet that has many cells/formulas protected so that the data
stays accurate. I left certain cells unprotected for others to access and
fill in their information. The problem is that when trying to send the
worksheet as the message body only, not an attachment, an error pops up
saying--

"A sheet in the workbook you are trying to save is password protected.
Password protected sheets cannot be saved in a Web Page. To save this file
as a Web Page, you must first remove the password."

I would prefer not to have to send the workbook as an attachment, but am at
a loss for how to keep certain cells protected and be able to send as the
message body. Any suggestions?

Thank you--
Bambi

--

Dave Peterson