| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 29704 | 2003-01-30 06:36:00 | Excel 97 Protection | Happy Harry (321) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 117273 | 2003-01-30 06:36:00 | Hey there all you Excel Gurus I'm running Excel 97 under WIN XP Pro and have set up a Workbook with 7 sheets in it. It is set up so the 1st 6 sheets are for my bi-monthly GST figures and the 7th for a summary for the first 6 sheets. What I wish to do, is protect the formatting (column width, height, fonts etc.) and the formalas, so that I can erase the contents of cells without effecting anything else. Under "Tools" "Protection" there are 3 options but do not seem to do what I want as with protection turned on I am still able to change formatting. I searched under "help" for locking cells as I seem to have a recollection of this, but there was not any info. Hope someone can point me in the right direction Cheers Happy Harry |
Happy Harry (321) | ||
| 117274 | 2003-01-30 06:47:00 | Search the Excel VBA help file for "protection". There is a setting available in VBA which can do what you want. It's something like xlVeryHidden. It's a while since I used Excel, hence my vagueness. You may also want to take a look here (www.j-walk.com) |
antmannz (28) | ||
| 117275 | 2003-01-30 07:51:00 | You need to format the cells with the data. Right click the cells and select properties. Go to the 'protection' tab and remove the tick from 'locked'. When you protect the sheet the data cells will not be protected, but the cells containing the formulas will be. |
wotz (335) | ||
| 117276 | 2003-01-30 10:51:00 | The above replies may achieve what you want. However, if you wish to erase your data for one period so that you can fill in a fresh set for the next an alternative approach is to create and save a "blank" file which has all the formatting, headings, links, formulae etc but no data. Then for each period you simply call up the "blank", rename it and fill in the new data. If you do adopt this method I recommend that you also make a backup copy of the "blank" as it is very easy to fill in the "blank" and resave it without renaming, thus overwriting the blank. I save the blanks with the extension .blk and the backups .bak and you can just change the extension to distinguish the data files - eg .203 can indicate (GST) period 2 for year 03. | Robin S_ (86) | ||
| 117277 | 2003-02-02 04:41:00 | Hi to all Replyers Thanks to all that replied and sorry for the delay as I have not been able to Logon to F1 because of the problems they are having. Once I digested the information and figured out the reverse logic of turning off cells so they are protected ?? I acheved what I wished to do. I dragged the LOCK ICON onto the tool bar for instant access and for future memory jogging Cheers HH |
Happy Harry (321) | ||
| 1 | |||||