Can you fix this?? vbreadonly
All, I seem to have solved my problem with not being able to restrict th workbook if its attribute is read only.....instead of using I GetAttr(.Name)=1 Then Exit Sub i used the line I ActiveWorkbook.ReadOnly Then Exit Sub. This seems quite neat as if th original is opened again while already being edited then it will no make another copy! Thanks to all that replied and all those who are working on th problem. Simo -- Simon Lloy ----------------------------------------------------------------------- Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670 View this thread: http://www.excelforum.com/showthread.php?threadid=25742 |
All times are GMT +1. The time now is 05:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com