View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default setting permissions programatically

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.

--
Regards,
Tom Ogilvy


"Kevin H" wrote:

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!
--
Regards,

Kevin