Excel Workhseet

Anirudh · 03-02-2008, 08:47 PM

Hi

Could we make one particular worksheet read-only, in the group of 31 sheet in the same file?

Regards,

Anirudh

**gistek** · 03-02-2008, 10:39 PM

I clicked on Excel Help and entered, "lock cells" in the search box. the first entry was, "Protect worksheet or workbook elements"

I think that might help you.

nik01 · 03-05-2008, 08:50 AM

Hi Anirudh, which excel version are you using?
For microsoft 2007 version YES you can.

Stumpy81 · 03-06-2008, 05:29 AM

Hi Anirudh,

Is Nik01 said, you can do it but in all version of excel starting from 2000.
Just go into Tools > Protection.

When you would ever face any issues, please tell me here of via a PM.

Kind regards,
Stumpy

Anirudh · 03-22-2008, 09:08 AM

Hi All,

Thanks for ur suggestions,however my query is not been solved yet,
Because I don't want to protect the sheet, I want to make that single sheet read only in the set of 31 odd sheet in the same file.So that all the other users can access the sheet but they can't edit.

Hi Nik01,

You have mentioned it (that above mentioned task) is possible in MS Excel 2007, is it true?

Kind Regards,

Anirudh

**Glaswegian** · 03-22-2008, 09:28 AM

The advice already posted will protect the sheet from any editing. Is this not what you are trying to achieve?

nik01 · 03-23-2008, 03:02 PM

Hi
Anirudh
In 2007, click on the sheet that requires to be protected then click the 'Review' Tab.
Next go to the 'Changes' section and click 'Protect Sheet' and enter a passcode, you will then be asked to confirm it. This will be for the sheet only, the rest of the work book will remain open to other users to edit.

03-02-2008, 08:47 PM	#1 (permalink)
Anirudh Registered User Join Date: Mar 2008 Location: Pune Posts: 5 OS: Window XP	Excel Workhseet Hi Could we make one particular worksheet read-only, in the group of 31 sheet in the same file? Regards, Anirudh

03-02-2008, 10:39 PM	#2 (permalink)
gistek Folding Along Join Date: May 2007 Location: PA, USA Posts: 1,919 OS: Bobbi=xp, sp3 Muse=Vista Home Premium	Re: Excel Workhseet I clicked on Excel Help and entered, "lock cells" in the search box. the first entry was, "Protect worksheet or workbook elements" I think that might help you. __________________ I am not a computer professional, My advice comes from personal experience and/or friends who are computer professionals. Learn By Doing Un-versity Interested in Search and Rescue? Check out the Civil Air Patrol. Come Fold with us. TSF Folding@Home Team

03-05-2008, 08:50 AM	#3 (permalink)
nik01 Registered User Join Date: Feb 2008 Location: Nottingham, England Posts: 23 OS: vista Premium & XP	Re: Excel Workhseet Hi Anirudh, which excel version are you using? For microsoft 2007 version YES you can.

03-06-2008, 05:29 AM	#4 (permalink)
Stumpy81 Registered User Join Date: Feb 2008 Location: Belgium Posts: 60 OS: Vista Ultimate	Re: Excel Workhseet Hi Anirudh, Is Nik01 said, you can do it but in all version of excel starting from 2000. Just go into Tools > Protection. When you would ever face any issues, please tell me here of via a PM. Kind regards, Stumpy

03-22-2008, 09:08 AM	#5 (permalink)
Anirudh Registered User Join Date: Mar 2008 Location: Pune Posts: 5 OS: Window XP	Re: Excel Workhseet Hi All, Thanks for ur suggestions,however my query is not been solved yet, Because I don't want to protect the sheet, I want to make that single sheet read only in the set of 31 odd sheet in the same file.So that all the other users can access the sheet but they can't edit. Hi Nik01, You have mentioned it (that above mentioned task) is possible in MS Excel 2007, is it true? Kind Regards, Anirudh

03-22-2008, 09:28 AM	#6 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,533 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: Excel Workhseet The advice already posted will protect the sheet from any editing. Is this not what you are trying to achieve? __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

03-23-2008, 03:02 PM	#7 (permalink)
nik01 Registered User Join Date: Feb 2008 Location: Nottingham, England Posts: 23 OS: vista Premium & XP	Re: Excel Workhseet Hi Anirudh In 2007, click on the sheet that requires to be protected then click the 'Review' Tab. Next go to the 'Changes' section and click 'Protect Sheet' and enter a passcode, you will then be asked to confirm it. This will be for the sheet only, the rest of the work book will remain open to other users to edit.