Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 477
Default Protect Sheet - Allow formatting - On MAC

I'm assisting a client (who uses exclusively Mac's - so Excel-Mac Ver)
They have a protected sheet - The file was last saved by me on
my PC version where I was aked to expand there editing rights
from only the 2 basic settings (on tht PC) of Select locked cells and
Select Unlocked cells to (on the PC) Format cells, Format Rows and
Format columns. These last three changes didn't get set (internally)
when they loaded it. When I instructed them to go to Tools, Protection..
Protect Sheet... << there dialog box doesn't show the long list of options
that appear on the PC version. Where does one go <<on the MAC to
Allow Formatting of cells, rows and columns??

Also, Under there Preferences (PC's Tools, Options) they have the
Move selections after enter set to DOWN but it only works for the Enter/
Return Key - not the Enter/Return key on the Numeric Pad. How would
they change to numberic Pad enter key to also move down versus Across
to the RIGHT as it is doing at present?

TIA,

Jim May
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
How do I protect formatting only? ecav Excel Discussion (Misc queries) 6 January 11th 07 01:53 PM
Protect Workbook Vs Protect Sheet Poor_pakistani New Users to Excel 4 May 25th 06 02:06 PM
Can I protect columns w/in a "List" using Protect Sheet? Diane Excel Discussion (Misc queries) 0 May 10th 06 03:30 PM
Protect formatting & formula Scott Excel Discussion (Misc queries) 1 December 18th 05 11:40 PM
protect formatting Esmerelda Excel Discussion (Misc queries) 0 March 3rd 05 01:57 PM


All times are GMT +1. The time now is 04:08 PM.

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

About Us

"It's about Microsoft Excel"