Protect sheet & edit range with password

P

PatrickL

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi.
I have a worksheet originally created on a PC in Excel 07.
The sheet is protected but specific cells/ranges are editable (using a password of "").
In Excel 08 I can remove the protection to edit the whole sheet but cannot work out how to reinstate the protection so the specific cells are again editable.
Can you help?
Thanks
Patrick
 
C

CyberTaz

Range Protection isn't an option in the Mac version of Excel. Sheet
Protection is either On or Off & applies to cells retaining their Locked
property as well as the Scenarios & Objects on the sheet.

If you think this is a desirable feature you might take a moment to use
Excel's Help> Send Feedback mechanism to contact MS.

Regards |:>)
Bob Jones
[MVP] Office:Mac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PC excel 07 Vs Mac Excel 08 1
Sheet Protected but Cannot Unprotect 2
Cell protection only 5
Highlighting top row to last row in sheet 2
arrow keys move entire sheet , not from cell to cell 7
Partially protected sheet in Excel 2007 (Win)turns into fully protected sheet 1
Different Colored Sheet Tabs in Excel? 1
Excel find replace not active 5

Top