Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Set as read only based on user name.


How secure do you need the file? Remember, all a user has to do is
Disable Macros <before opening your workbook and your macro is dead.
If your user is savvy enough to know how to change the user name, they
probably know enough to disable macros.

You can protect workbooks/worksheets without a password that will help
prevent accidental changes. However, if someone is intent on gaining
access, there is not a lot you can do to stop them. Excel is not meant
to be 'secure'.

Good Luck.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=475174

Reply
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
Spreadsheet defaults to Read Only for ONE user... DS Excel Discussion (Misc queries) 6 July 12th 06 02:50 PM
Spreadsheet defaults to read-only for ONE user only?? DS Excel Discussion (Misc queries) 3 July 4th 06 04:58 PM
New user help and Excel read question (Interop and OleDb) sporadic Excel Programming 0 June 2nd 05 08:18 PM
New user help and Excel read question (Interop and OleDb) sporadic Excel Programming 0 June 2nd 05 07:55 PM
Can I set up a worksheet as read only for one user Classic Excel Programming 1 December 7th 04 04:18 PM


All times are GMT +1. The time now is 08:06 PM.

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

About Us

"It's about Microsoft Excel"