ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need VBA Code to Open a Workbook in read only (https://www.excelbanter.com/excel-discussion-misc-queries/98472-need-vba-code-open-workbook-read-only.html)

zulfer7

Need VBA Code to Open a Workbook in read only
 
I want a code that would verify the application.username is one of 4
different users and if not that it would open the workbook in "READ-ONLY".
Do you have anything like that or is it easy to make?

raypayette

Need VBA Code to Open a Workbook in read only
 

You can restrict access to your workbooks using Microsoft Information
Rights Management. Click File, Permission, Restrict permissions as..
once you have an IRM server or you have subscribed to Microsoft's
server.


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=560088



All times are GMT +1. The time now is 12:49 PM.

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