Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 11th 09, 12:40 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2009
Posts: 1
Default Setting up protection on a workbook

I am setting up a workbook and I am wondering if you can put protection on it
to prevent some users from inserting / deleting rows but allow other users
(people that will be doing maintenance on the file) to delete / insert rows
without having to remove the protection every time?

  #2   Report Post  
Old January 11th 09, 12:55 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default Setting up protection on a workbook

You should simply use password protection, but if you want to avoid the
manual effort of disabling and then re-enabling protection, you can use the
workbook open event macro:

Private Sub Workbook_Open()
If Environ("username") = "James" Then
' clear desired workbook and worksheet protections
Else
' set desired workbook and worksheet protections
End If
End Sub

or something similar
--
Gary''s Student - gsnu200825


"brown1965" wrote:

I am setting up a workbook and I am wondering if you can put protection on it
to prevent some users from inserting / deleting rows but allow other users
(people that will be doing maintenance on the file) to delete / insert rows
without having to remove the protection every time?

  #3   Report Post  
Old January 11th 09, 11:00 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3,346
Default Setting up protection on a workbook

Hi,

The answer to this question might be more complicated if you are 1. Only
trying to allow the users to insert and delete rows, 2. If different users
can work with different ranges only.

In the second case you might consider the Tools, Protection, Allow Users to
edit range option.

In the first case you should consider VBA which prompts users for a password
or logon name and then sets the protection to allow only inserting and
deleting rows. With this routine you will need to add a before save or
before close macro which resets the protection back to complete.

If the users who can modify the workbook can make any modifications and
those that can't, can't make any modifications, then you might consider Read
Only with a password.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"brown1965" wrote:

I am setting up a workbook and I am wondering if you can put protection on it
to prevent some users from inserting / deleting rows but allow other users
(people that will be doing maintenance on the file) to delete / insert rows
without having to remove the protection every time?



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
Workbook protection christine b Excel Discussion (Misc queries) 1 October 24th 08 01:43 PM
Workbook protection micksa Excel Discussion (Misc queries) 3 April 15th 08 01:40 PM
Workbook protection Baldyman Excel Discussion (Misc queries) 2 December 7th 07 09:49 PM
Password protection excel document - last user setting lost Jon's problem Excel Discussion (Misc queries) 0 October 23rd 07 11:52 PM
how can i remove workbook protection setting??? raviv Excel Discussion (Misc queries) 1 June 10th 05 07:36 PM


All times are GMT +1. The time now is 11:29 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017