|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 1st, 2010, 11:45 PM
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
June 1st, 2010, 11:55 PM
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
June 2nd, 2010, 03:08 AM
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
June 2nd, 2010, 12:14 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
