ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you protect hidden linked worksheets with in an Excel workb (https://www.excelbanter.com/excel-discussion-misc-queries/73052-how-do-you-protect-hidden-linked-worksheets-excel-workb.html)

Newsgal

How do you protect hidden linked worksheets with in an Excel workb
 
I have several worksheets linked to other worksheets in an Excel workbook. I
want to e-mail the workbook to several different groups with each group only
being able to view specific worksheets. Is it possible to hide and then
protect the worksheets so that there are different passwords each group uses
to only access the sheets we want them to see?
--
News Gal

Ron de Bruin

How do you protect hidden linked worksheets with in an Excel workb
 
hi Newsgal

Why not send only the sheets you want and convert to values
See my mail page for examples
http://www.rondebruin.nl/sendmail.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Newsgal" wrote in message ...
I have several worksheets linked to other worksheets in an Excel workbook. I
want to e-mail the workbook to several different groups with each group only
being able to view specific worksheets. Is it possible to hide and then
protect the worksheets so that there are different passwords each group uses
to only access the sheets we want them to see?
--
News Gal





All times are GMT +1. The time now is 07:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com