Emailing a password protected worsheet
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 |
Emailing a password protected worsheet
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 |
All times are GMT +1. The time now is 05:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com