Protect but allow changes

Hi All,

I would like to protect a worksheet but allow others to 
change column width and format numbers. Is that possible 
and how do I do this? Thank you for your help.

Regards
0
anonymous (74722)
11/30/2004 3:25:14 PM
excel 39879 articles. 2 followers. Follow

4 Replies
793 Views

Similar Articles

[PageSpeed] 10

It depends on what version of excel you have, when you protect the sheet 
check allow format cells and format columns if you have this option
-- 
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

<anonymous@discussions.microsoft.com> wrote in message 
news:a25401c4d6f0$c9f358c0$a401280a@phx.gbl...
> Hi All,
>
> I would like to protect a worksheet but allow others to
> change column width and format numbers. Is that possible
> and how do I do this? Thank you for your help.
>
> Regards 


0
11/30/2004 4:14:46 PM
If using Excel 2002 or 2003 you have the option when protecting the sheet of
allowing users to do certain operations on the sheet.

Earlier versions would require a macro to unprotect then re-protect the sheet.

ActiveSheet.Unprotect Password:="justme"

'do your stuff

ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
            Contents:=True, Scenarios:=True

Gord Dibben Excel MVP

On Tue, 30 Nov 2004 07:25:14 -0800, <anonymous@discussions.microsoft.com>
wrote:

>Hi All,
>
>I would like to protect a worksheet but allow others to 
>change column width and format numbers. Is that possible 
>and how do I do this? Thank you for your help.
>
>Regards

0
Gord
11/30/2004 4:24:45 PM
Thanks. Unfortunately, I am still using Excel 2000. 
Thanks for your help.


>-----Original Message-----
>It depends on what version of excel you have, when you 
protect the sheet 
>check allow format cells and format columns if you have 
this option
>-- 
>Paul B
>Always backup your data before trying something new
>Please post any response to the newsgroups so others can 
benefit from it
>Feedback on answers is always appreciated!
>Using Excel 2002 & 2003
>
><anonymous@discussions.microsoft.com> wrote in message 
>news:a25401c4d6f0$c9f358c0$a401280a@phx.gbl...
>> Hi All,
>>
>> I would like to protect a worksheet but allow others to
>> change column width and format numbers. Is that 
possible
>> and how do I do this? Thank you for your help.
>>
>> Regards 
>
>
>.
>
0
anonymous (74722)
11/30/2004 5:48:54 PM
couldn't you just format/cells/unlock the area you want left modifiable?

txag


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:ki7pq0l4ci2m7jie5963sbm96p4r55apcm@4ax.com...
> If using Excel 2002 or 2003 you have the option when protecting the sheet
of
> allowing users to do certain operations on the sheet.
>
> Earlier versions would require a macro to unprotect then re-protect the
sheet.
>
> ActiveSheet.Unprotect Password:="justme"
>
> 'do your stuff
>
> ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
>             Contents:=True, Scenarios:=True
>
> Gord Dibben Excel MVP
>
> On Tue, 30 Nov 2004 07:25:14 -0800, <anonymous@discussions.microsoft.com>
> wrote:
>
> >Hi All,
> >
> >I would like to protect a worksheet but allow others to
> >change column width and format numbers. Is that possible
> >and how do I do this? Thank you for your help.
> >
> >Regards
>


0
no2594 (35)
12/1/2004 8:13:39 PM
Reply:

Similar Artilces:

Protect sheet but allow sorting only
I'm using Excel 2003, and I've tried to allow only sorting on a protected sheet. I've tried by choosing Tools, Protection, Protect Sheet. Next, I've checked the sort check box in the "Allow all users of this worksheet to:" area. The only other check boxes that are checked are the "Select locked cells" and "Select unlocked cells" boxes. When I test the protected worksheet I am still unable to sort. Am I missing something? Thanks! -- Christina "Christina" <Christina@discussions.microsoft.com> wrote in message news:E37A3...

Change only size of a thumb (CSliderCtrl)
When I extend size of CSliderCtrl, size of a thumb also grows as same ratio. Is there anyway to change size of thumb independently? i think they are bound together. The only way to do that is, you derive a your own sliderctrl, and do the draw work by yourself. ...

Change IP Address of passive node in CCR
We have a CCR cluster on Windows Server 2008. The cluster is formed over a stretched subnet. Setup is as follows: Node01 - 10.0.31.50 and 10.0.32.50 Node02 - 10.29.1.50 and 10.29.2.50 We need to move Node02 to a new building which involves changing the IP addresses. Anyone got some help or assistance on doing this? Any gotchas to look out for? Appreciate your advice. ...

Outlook replication changes valid email to lastname firstname
CRM 4.0, Outlook 2007, CRM Outlook Online Client with latest Rollup. When some users are sync contact information between Outlook and CRM, sync changes email address firstname.lastname@company.com in CRM to format lastname firstname. Not happen to all users. One reason can be there are also mobile sync between Outlook (Exchange) and mobile phone. But this is also used by many users and only some have problems. It is look like email is populated with Outlook display value, not the real email. Any ideas what setting (and where) is not right? Jukka Majander ...

Change subform from a subform
I have a form named frmToday with a subform named frmMyView. The default subform for frmMyView is frmCalls. I change this with a button by using a private Sub routine Forms!frmTODAY!frmMYVIEW.Form.SourceObject = "frmDupes." I have a button on frmDupes with Forms!frmTODAY!frmMYVIEW.Form.SourceObject = "frmCalls" as a Private Sub routine. The intent is to change back to the original setup. It doesn't work. What do I need to do? Thanks! ...

Changing Inventory Item Types #2
In GP7.5, is there any way to change inventory item types once they have been used? Can the item be deleted and then recreated at the end of a year? Are there any utility programs that can do this? In particular, I've got some "sales inventory" items that I want to convert to "kits" and others that need to be "services" We are on 8.0, but I don't think it is possible to change the item type - not even with Professional System Tools. We have changed the item name (via tools) to include the word Discontinued. Then we set up a new item to repl...

Manage your all passwords and protect your privacy in secure way!
Hello all, PrivacySafer 2007 can manage your all passwords(Windows network logon, your e-mail account, your homepage's ftp password, online passwords, your bank account, etc. etc. etc.) in a secure way and protect your private data(bussiness docment, personal photos, secrets etc) and deter malewares(keylogger, Trojans etc). Main features: - Strong Security - Multiple User Keys - Portable and runs on all windows system - Easy Database Transfer - Support of Password Groups - Time Fields and Entry Attachments - Auto-Type, Auto-login into your app(game,email,ftp etc), Global Au...

Changing row height in a CListCtrl
Hello, I'm trying to change the row height of a list control by means of a slider. Currently, we're doing that by changing the font height. This works perfectly, except for one thing: The font actually changes as well (d'uh). For the items itself it's not really a huge issue, I'm using custom draw and can set the font height to a "fixed" value. But I can't do that for the headers. Is there perhaps another way to change the row height of a list control, or is changing the font height the only way to do it? Thanks, -- Maarten Kools ___________________...

Refresh pivot chart when info in a cell changes
To all, I am looking for help with a Macro. What I ultimately want to do is refresh a pivot chart when the user makes a selection from a list (in a data validation cell). For example, I am an end user that selects my territory from a "drop down". The pivot chart will update to the information that is directly related to my territory. Thanks in advance for your help. Excel 2007, PivotTable With Table dependent drop-downs instead of data validation drop-downs. With non-event-driven macros. http://www.mediafire.com/file/ygzjqyi2j1x/03_09_10.xlsm ...

The reference in the formula has changed to eg =R[-1]C/R[-237]C
I don´t know how it has happened, but I want to read the formula as eg =sum(A2/Z18) Old documents are shown like this and my new ones come out like this too. Help, anyone out there?! Merry X-mas from Sweden :-) -- Kajsa Excel 2003:- Tools>>Options>>General>>Uncheck the R1C1 Reference Style checkbox and give ok Excel 2007:- Click the Office Ribbon Button (colorful round circle at the top Left corner)>Excel Options>Formulas>>Working With Formulas>> Uncheck the R1C1 Reference Style checkbox and give ok. Remember to Click Yes, if t...

Cell colour change trigger event
Hi, I have a whole bunch of cells which are formatted differently based on a master set of cells. What I'm trying to do is, when the user changes the colour of any of the cells in the master set, the other cells with the previous same formatting should accordingly. Unfortunately, it doesn't seem like formatting changes trigger a recalculation. My code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim k As Integer If Not (Target.MergeCells And IsInRange(Target, Range("colorLegend"))) Then Exit Sub End If If legendMap...

Payroll should allow concurrent builds by different users
In a company that is heavy payroll, all checks are processed in the same day but by different users for different subsets of employees. Allowing concurrent builds would be nice. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolution...

Publish Form Changes without restarting IIS?
Is there another way to publish form changes without restarting IIS? We run a 24x7 IT shop and taking down a production system for every change is a pain. thank you. Mike Presumably as you are 24/7 you have multiple CRM servers, so you only need to IISRESET one CRM server at a time, thus users will not notice any loss of service "BWIT" <user1@bwinc.com> wrote in message news:ObSXFVvWFHA.4036@TK2MSFTNGP10.phx.gbl... > Is there another way to publish form changes without restarting IIS? We > run a 24x7 IT shop and taking down a production system for every chang...

How do you change the formatting for envelops in the normal templ.
the envelop paragraph formatting is 1.15 and 10 pt at end - this is not what I want - How do I change it to be single and 0 pts for all documents based on the normal template? Modify (or reset) the Envelope Address style, which by default does not have these characteristics. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "dcluchi" <dcluchi@discussions.microsoft.com> wrote in message news:EEA62CD4-57AA-4E9F-9D63-3BE505D1FDDD@microsoft.com... > the envelop paragraph formatting is 1.15 and 10 pt at e...

Protect a table in word
Hi, I'm trying to protect a table layout which has been created in word, but want to be able to edit the text within the tables colums and rows Do you mean fixed width columns? What part of the layout are you wanting to protect, and what version of Office /Word are you using? -- Susan Ramlet -- please reply to the newsgroup so all may benefit. "emerald" <emerald@discussions.microsoft.com> wrote in message news:A0015165-61A8-4531-BA6D-7FD57D3F4487@microsoft.com... > Hi, > I'm trying to protect a table layout which has been created in word, but ...

Protecting worksheets with Macros in Shared Workbooks
Hi All, I have a spreadsheet which has many worksheets and macros. In general, the spreadsheet is protected. However, in the spreadsheet there are macros that unprotect worksheets, do tasks then reprotect. I want to make it a shared workbook. However, there seems to be a problem with the protection which is something to do with the fact it is a shared workbook. Basically, i get a message saying "unprotect method of worksheet class failed". I am using the standard method: ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True What are the particulars of this...

General Ledger Beg Balance change.
How do you change the beginning balance that has rolled from a closed year that is no longer accessible?. For example, I need to change the 2004 Beginning Balance for a general ledger account. The balance came from 2003 but because of system limitations, I cannot go back to 2003. How do I correct the beginning balance for 2004? Ogle, From what I know you can only make changes to the last historical year. Though this can be accomplished from the back-end, I doubt this can be done using the front end. If you are SOX compliant, then back-end is a big no no. Girish "JR Ogle"...

Change Hyperlink Destination Folder
In an Excel 2002 worksheet I need to change the destination folder in a column (750 rows) of hyperlinks. For example: file:///C:\Documents and settings\myname\Application Data\Microsoft\Data\12345.mht needs to be changed to file:///E:\My Documents\Travel\2005\Data\12345.mht file:///C:\Documents and settings\myname\Application Data\Microsoft\Data\56789.mht changed to file:///E:\My Documents\Travel\2005\Data\56789.mht All the ".mht" files are now in the folder E:\My Documents\Travel\2005\Data\ TIA Why don't you do a find and replace. Replace it with some...

Change Sheet "TAB" colour?
Is there a way to change the colour of one "Sheet Tab" , among 12 others? Right click the tab, choose color. "Kane" wrote: > Is there a way to change the colour of one "Sheet Tab" , among 12 others? Right click on the tab and select tab color. "Kane" wrote: > Is there a way to change the colour of one "Sheet Tab" , among 12 others? If you have Excel 2002, or later version, right-click on the sheet tab Choose Tab Color, and select a colour. There's a picture in the Excel FAQ: http://www.contextures.com/xlfaqApp.html#TabCol...

Excel 2007 chart color change based on the label.
I have 12 charts 1 for each person and the data changes every week and some of the values have 0 so are filtered out. On the chart I want 0-15 to be blue, 16-30 to be light purple, 31-60 to be a cream color, 61-90 to be light blue, and 90+ to be dark purple. With the code below I can change the color if I take the if statement out but I would like to change the color based on the label. I have tried several things like .text, .name, and .label. I just can't fine the right name. Name1 0-15 1 61-90 1 90+ 3 Name 2 0-15 14 16-30 5 31-60 1 61-90 6 90+ 12 For i = 1 To A...

Changing Default Character Set
Do I have to restart Exchange services when I change the default character set? I have Blackberry users who send mail from their Blackberrys to other employees on the E2K server, but the employees can't read the message because its all garbled text. RIM says its because the default character set is set to Western European (ISO8859-1). They said to change it to Latin I (Windows 1252). ...

Making cell change colour
Hi all I want to make a cell change colour 'on click'. Is there any way that this is possible? Help would be appreciated, Many thank darren --- Message posted from http://www.ExcelForum.com/ Hi this would require VBA / using an event procedure like Selection_change. Do you want to go this way? -- Regards Frank Kabel Frankfurt, Germany > Hi all > > I want to make a cell change colour 'on click'. > > Is there any way that this is possible? > > Help would be appreciated, > > Many thank > > darren > > > --- > Message posted f...

How to change the scan code while posting WM_KEYDOWN and WM_KEYUP messages?
Hello, I am working with win32 serial communication in VC++. My application communicates with a Control Panel hardware device which is similar to a Keyboard. It has various keys/buttons ("0-9 digit keys, A-Y alphabet keys and F1,F2,F3 keys") on it , and is connected through the serial port of the PC. My application has to capture which key/button is pressed and released on the Control Panel board. When a key/button is pressed or released on the Control Panel board, my application should post the appropriate message to the main handling application which is responsible for processing...

"allow" you gotta be kidding
I cannot sign in with my passport. I have tried signing in to other places and that "allows" me to do that. I have a bunch of bills that need paying so if anyone would like to pay them for me, that would be fine. What is this...will NOT allow me Are we talking "The sign-in name you entered is not associated with this file"? If so, it's been the subject of maybe a thousand posts over the last two weeks or so. See news://msnews.microsoft.com/eG2ikZfdEHA.3044@TK2MSFTNGP10.phx.gbl or http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=eG2ikZfdEHA.3...

Only allowing certain inputs into cells
I have a whole list of cells that formulas calculate off of that are based on 3 entrys into the cells. Either a -, 0, or 1. Is there a way to set the cell so that only one of those 3 characters can be entered? and if so, how do I do that? Thanks greatly. Hi David Check out Data>Validation in the menubar Choose list and type a,0,1 -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "David C. Glasgo" <anonymous@discussions.microsoft.com> wrote in message news:020801c39a59$0bf46a00$a301280a@phx.gbl... > I have a whole list of cells that for...