Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell
Hi,
On the old Excel you could hide a file and every time you load excel it would be in the background. With the new 2007 you can hide the files but when you close down excel and re open they are missing and you have to reopen them any ideas? -- Sue |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell
Files saved in the XLSTART folder will automatically open when Excel is
opened. Also if you go to the Advanced group in the Excel Options feature, under General there is a box in which you can specify another folder that will act the same. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Sue Parsons" wrote in message ... Hi, On the old Excel you could hide a file and every time you load excel it would be in the background. With the new 2007 you can hide the files but when you close down excel and re open they are missing and you have to reopen them any ideas? -- Sue |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell
Hi,
I am trying to use protect only it protects the whole sheet i have looked at the answers but am unable to get all but a few cells locked it seems all or nothing? Has any one ele had the same problem. -- sue |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell
Hi Sue
By default, all cells have their values set to Locked. When Sheet Protection is then invoked, all cells would be Locked. Before Applying ToolsProtection, select the range of cells you want to leave Unprotected, then choose FormatCellsProtection and clear the tick from Locked. Now apply your Sheet protection. -- Regards Roger Govier "Sue Parsons" wrote in message ... Hi, I am trying to use protect only it protects the whole sheet i have looked at the answers but am unable to get all but a few cells locked it seems all or nothing? Has any one ele had the same problem. -- sue |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell
Sorry still does not work i am using vista will this be a problem and 2007
excel? -- sue "Roger Govier" wrote: Hi Sue By default, all cells have their values set to Locked. When Sheet Protection is then invoked, all cells would be Locked. Before Applying ToolsProtection, select the range of cells you want to leave Unprotected, then choose FormatCellsProtection and clear the tick from Locked. Now apply your Sheet protection. -- Regards Roger Govier "Sue Parsons" wrote in message ... Hi, I am trying to use protect only it protects the whole sheet i have looked at the answers but am unable to get all but a few cells locked it seems all or nothing? Has any one ele had the same problem. -- sue |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell
Hi,
Thanks i have tried again and it worked thanks again -- sue "Roger Govier" wrote: Hi Sue By default, all cells have their values set to Locked. When Sheet Protection is then invoked, all cells would be Locked. Before Applying ToolsProtection, select the range of cells you want to leave Unprotected, then choose FormatCellsProtection and clear the tick from Locked. Now apply your Sheet protection. -- Regards Roger Govier "Sue Parsons" wrote in message ... Hi, I am trying to use protect only it protects the whole sheet i have looked at the answers but am unable to get all but a few cells locked it seems all or nothing? Has any one ele had the same problem. -- sue |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell
Hi Sue
No it makes no difference which operating system or which version of Excel - it works the same. With Excel 2007 however, you don't have to use ToolsProtection to switch on protection for the sheet, you just right click on a sheet tab, and one of the options that appears is Protect Sheet. -- Regards Roger Govier "Sue Parsons" wrote in message ... Sorry still does not work i am using vista will this be a problem and 2007 excel? -- sue "Roger Govier" wrote: Hi Sue By default, all cells have their values set to Locked. When Sheet Protection is then invoked, all cells would be Locked. Before Applying ToolsProtection, select the range of cells you want to leave Unprotected, then choose FormatCellsProtection and clear the tick from Locked. Now apply your Sheet protection. -- Regards Roger Govier "Sue Parsons" wrote in message ... Hi, I am trying to use protect only it protects the whole sheet i have looked at the answers but am unable to get all but a few cells locked it seems all or nothing? Has any one ele had the same problem. -- sue |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
create a slides show with excell spreadsheets using excell | Charts and Charting in Excel | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
how do you open an excell email attacment, if I dont have excell | Excel Discussion (Misc queries) | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) |