 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2004How to protect sheet layouts and formatting?
I have a spread sheet setup to display values from lots of other sheets within the same workbook. only 77 cells require a user to input data, so I have set up protection so only these cells can be changed when protect sheet is enabled. problems I would love help with, please: 1) how can I now protect the formatting of these cells from being changed? but still allow users to input data? 2) stop other users from, renaming or deleting any other sheets within the workbook needed for this sheet to work, or inserting rows or columns in them? 3) all without password protecting the file? Kind regards, Steve Hi have a look at 'Tools - Protection' and see the Excel help for more details. You can allow entries for specific cell by going to 'Format - Cells - Protection' and unchecking 'Locked' After this protect the worksheet and the workbook  Signature-- Regards Frank Kabel Frankfurt, Germany > I have a spread sheet setup to display values from lots of other > sheets within the same workbook. only 77 cells require a user to [quoted text clipped - 15 lines] > > Steve I have done that with the cells in question on the main sheet, but if you copy a cell that has a black outline to another cell, the outline is also pasted, I would like just the value in the cell to be copied. I know using paste special will sort this but not everyone using this spreadsheet will. > Hi > have a look at 'Tools - Protection' and see the Excel help for more [quoted text clipped - 27 lines] > > > > Steve Hi Steve not quite sure but you may use 'Edit - Paste Special - Values' for pasting your values Signature-- Regards Frank Kabel Frankfurt, Germany > I have done that with the cells in question on the main sheet, but if > you copy a cell that has a black outline to another cell, the outline [quoted text clipped - 34 lines] >>> >>> Steve |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.