LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jay Jay is offline
external usenet poster
 
Posts: 671
Default Can .xls make itself ReadOnly?

I'm looking for transparent alternatives to the built-in procedures that make
a workbook 'read-only.' Specifically, I'm looking for a way for a workbook
(that is not read-only) to make itself read-only each time it opens.

I'm searching for this solution because in my application, it is confusing
for users to see the "Password" dialog that states that "...the file is
reserved by... Enter a password for write access, etc....". The standard
approach to suppressing this dialog with application.displayalerts=false does
not work when implemented in the WorkBook_Open event procedure of the
ThisWorkbook object.

Also, I've checked the File's ReadOnly attribute in Windows Explorer, but
when emailed to another user, this attribute gets cleared (unchecked)
---
Thanks for any advice you VBA RockStars can provide,
Jay
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing file from readonly Niall Excel Discussion (Misc queries) 2 July 27th 06 04:58 PM
make single column of the sheet as readonly .NetProf Excel Programming 2 January 30th 06 02:09 PM
Readonly files nc Excel Discussion (Misc queries) 2 March 18th 05 11:13 AM
Readonly pauluk[_10_] Excel Programming 1 March 3rd 04 12:43 PM
Open As Readonly SCSC[_2_] Excel Programming 5 February 4th 04 05:14 PM


All times are GMT +1. The time now is 02:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"