Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default Restricting access to workbook

How can I prevent others, but not all, from accessing a
workbook? I don't want certain people to see a given
workbook even in read-only fashion.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Restricting access to workbook

The easiest option is to save the file with something in the 'password
to open' field. That way the only people who can open it are those who
you give the password to.

This is not 100% effective as there are password crackers available, but
will keep out 'normal' users.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
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
restricting access using a macro Popeye the powerman[_2_] Excel Worksheet Functions 3 March 21st 09 07:16 AM
Sharing a Workbook But Restricting Access to Certain Sheets Brandy Excel Discussion (Misc queries) 4 June 16th 08 07:58 PM
Restricting access to a range of cells anandmr65 Excel Discussion (Misc queries) 1 July 26th 06 12:49 PM
restricting access to a worksheet? C.East Excel Discussion (Misc queries) 2 April 5th 06 10:02 PM
restricting access to workbook pam Excel Programming 1 December 12th 03 08:31 PM


All times are GMT +1. The time now is 05:39 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"