setting permissions programatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am working on a project in which we need to set the permissions of the
target Excel file so that the user has exclusive editing permission (locks
out others to read-only permission). Since the target file could be any
number of files, we want to set this permission when the application begins
to open the target Excel file. Is this permission set at the Excel level or
the OS level? How would I go about setting this? The version of Excel we
are using is 2003, and win xp is the OS. Any help is greatly appreciated!
 
If you open the workbook on a shared drive, the first person to open it
should have exclusive editing permission as long as you have not shared the
workbook under the tools menu.
 
Thank you. That does help. Is there a way that I can check to see if the
workbook has the shared setting=true and if so, set it to false
programatically ( exclusive editing permission) while we are working with it?
I just want to code for any possible scenario.
 
Zack,
Have you ever tested that code on a shared workbook? With multiple people
using it? Just curious.
 
Hi Tom,

I briefly tested parts of it, and it seemed to work as advertised. Although
I haven't tested extensively.

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


Tom Ogilvy said:
Zack,
Have you ever tested that code on a shared workbook? With multiple people
using it? Just curious.
Click to expand...
 
Back
Top