Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking A Sheet Using Words & Numbers
Before I got Office 2007 I was able to lock a spreadsheet using a word
combined with numbers, i.e., locksheet123. Now I can't lock it using that formula I can only lock it using words, i.e., locksheet. If I try to put in the full words & numbers it allows me to do it in the first window, but when it asks for verification, in the second window, it tells me there's an error and I can't do it. -- Thanks, Mumsy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking A Sheet Using Words & Numbers
This is a silly guess...
I'm gonna guess that you made a typo -- either in the letters or numbers -- or even hit caps lock. I'd try it again if I were you. Mumsy wrote: Before I got Office 2007 I was able to lock a spreadsheet using a word combined with numbers, i.e., locksheet123. Now I can't lock it using that formula I can only lock it using words, i.e., locksheet. If I try to put in the full words & numbers it allows me to do it in the first window, but when it asks for verification, in the second window, it tells me there's an error and I can't do it. -- Thanks, Mumsy -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking A Sheet Using Words & Numbers
Dave, thanks for the input, but I tried that several times. There were no
typos. and, I've tried it on different occasions. -- Thanks, Mumsy "Dave Peterson" wrote: This is a silly guess... I'm gonna guess that you made a typo -- either in the letters or numbers -- or even hit caps lock. I'd try it again if I were you. Mumsy wrote: Before I got Office 2007 I was able to lock a spreadsheet using a word combined with numbers, i.e., locksheet123. Now I can't lock it using that formula I can only lock it using words, i.e., locksheet. If I try to put in the full words & numbers it allows me to do it in the first window, but when it asks for verification, in the second window, it tells me there's an error and I can't do it. -- Thanks, Mumsy -- Dave Peterson . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking A Sheet Using Words & Numbers
I don't have another guess.
Sorry. Mumsy wrote: Dave, thanks for the input, but I tried that several times. There were no typos. and, I've tried it on different occasions. -- Thanks, Mumsy "Dave Peterson" wrote: This is a silly guess... I'm gonna guess that you made a typo -- either in the letters or numbers -- or even hit caps lock. I'd try it again if I were you. Mumsy wrote: Before I got Office 2007 I was able to lock a spreadsheet using a word combined with numbers, i.e., locksheet123. Now I can't lock it using that formula I can only lock it using words, i.e., locksheet. If I try to put in the full words & numbers it allows me to do it in the first window, but when it asks for verification, in the second window, it tells me there's an error and I can't do it. -- Thanks, Mumsy -- Dave Peterson . -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i get numbers changed in words(english) in excel sheet? | Excel Discussion (Misc queries) | |||
Locking A sheet | Excel Discussion (Misc queries) | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
new sheet the cell doesn't let me type words & numbers | Excel Discussion (Misc queries) | |||
Words > Numbers (i.e. Vanity Phone Numbers) function | Excel Worksheet Functions |