LinkBack URL
About LinkBacks
Hi,
I dont want to alter the file attribute "read only".
Still, I need to know how i can open it in read-only mode by either double click a excel file or its shortcut.
Possible?
Thanks
C1
Hi,
I dont want to alter the file attribute "read only".
Still, I need to know how i can open it in read-only mode by either double click a excel file or its shortcut.
Possible?
Thanks
C1
Are you trying to protect the workbook?
You can lock the workbook and/or the worksheets..
http://office.microsoft.com/en-us/ex...010096837.aspx
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
I had this on-time, but deleted accidentally. I now forgot how i did this. It was some kind of alteration to the "target" section shortcut of the file. After this alteration, when double click the shortcut, the file would open in a read only mode.
We have a excel file on network that lot of us need to read. I am doing this is to keep people from opening the file and then even administrator wont be able to open the file for editing.
I am sure, its not the password protection of the workbook.
Thanks
C1
Microsoft 2010
http://www.technipages.com/excel-for...ad-only-prompt
If you are talking about your own files, save them as read-only reccomended when you save them. It is a check-box under Tools|General Options when you "Save As".
Kudos !!
Thanks for the help. Though its not a file shortcut solution, it still does the same service.
You can do something like this.Originally Posted by cadone
1) Either you can allow the file to open only for certain users
2) Either you can allow the file to open only for certain machines
or
3) Allow the file to open only certain number of days, months etc.
Here is a screen shot of the properties. This is the shortcut I had deleted accidentally. I could now recover from our backup. This one will open the file read only. Thanks for all the input from you guys.
Capture.PNG
These aren't the correct tabs for Excel 2011. Looks to me like all these worksheets/workbooks are set up protected/locked so you can't change anything. How do I unlock w/ Excel 2011??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks