ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Locking A Sheet Using Words & Numbers (https://www.excelbanter.com/excel-worksheet-functions/265005-locking-sheet-using-words-numbers.html)

Mumsy[_2_]

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

Dave Peterson

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

Mumsy[_2_]

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
.


Dave Peterson

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


All times are GMT +1. The time now is 09:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com