Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection and warning popup
I understand how to protect the whole sheet and allow certain cells to be
populated. two part question. 1) is there a way to allow the cursor to only spot or start with the unlocked cells? Almost like a fillable PDF? I had an excel sheet where it ignored the protected areas and only went to the unprotected user cells. 2) If the above cannot be done, how do you turn off that "this sheet is protected" popup? My users will find out they can't change the sheet, but don't want them to get as annoyed as I do when I accidently click the wrong cell. Thanks. -- Continuously think of new ideas and do what it takes to create it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection and warning popup
Ken
First..if using Excel 2002 or 2003 version you can set option to not select locked cells when setting up your ToolsProtectionProtect Sheet. There are several ways to set the TAB order on worksheet cells. See Bob Phillips' site for methods. http://www.xldynamic.com/source/xld.xlFAQ0008.html There is another method using VBA event code. If interested, post back for more detail and some sample code. Gord Dibben Excel MVP On Tue, 6 Dec 2005 16:38:02 -0800, Ken wrote: I understand how to protect the whole sheet and allow certain cells to be populated. two part question. 1) is there a way to allow the cursor to only spot or start with the unlocked cells? Almost like a fillable PDF? I had an excel sheet where it ignored the protected areas and only went to the unprotected user cells. 2) If the above cannot be done, how do you turn off that "this sheet is protected" popup? My users will find out they can't change the sheet, but don't want them to get as annoyed as I do when I accidently click the wrong cell. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection and warning popup
You can't change the message, but you can stop them from selecting locked cells
on a protected sheet. Option Explicit Sub auto_open() Dim wks As Worksheet Set wks = Worksheets("sheet1") With wks .Protect password:="hi" .EnableSelection = xlUnlockedCells End With End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ken wrote: I understand how to protect the whole sheet and allow certain cells to be populated. two part question. 1) is there a way to allow the cursor to only spot or start with the unlocked cells? Almost like a fillable PDF? I had an excel sheet where it ignored the protected areas and only went to the unprotected user cells. 2) If the above cannot be done, how do you turn off that "this sheet is protected" popup? My users will find out they can't change the sheet, but don't want them to get as annoyed as I do when I accidently click the wrong cell. Thanks. -- Continuously think of new ideas and do what it takes to create it. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection and warning popup
Thanks Gord, I will look at the link you provided, this helps a great deal.
I've not done much in excel, infact if any program this one may be my weakest in knowledge base. I would like to get a good direction on an Excel book, one that gives you the more unknown goodies and programming. I know VB a bit, used to know it like the back of my hand, but not using it for 14 months it is just starting to come back. Thank you again. -- Continuously think of new ideas and do what it takes to create it. "Gord Dibben" wrote: Ken First..if using Excel 2002 or 2003 version you can set option to not select locked cells when setting up your ToolsProtectionProtect Sheet. There are several ways to set the TAB order on worksheet cells. See Bob Phillips' site for methods. http://www.xldynamic.com/source/xld.xlFAQ0008.html There is another method using VBA event code. If interested, post back for more detail and some sample code. Gord Dibben Excel MVP On Tue, 6 Dec 2005 16:38:02 -0800, Ken wrote: I understand how to protect the whole sheet and allow certain cells to be populated. two part question. 1) is there a way to allow the cursor to only spot or start with the unlocked cells? Almost like a fillable PDF? I had an excel sheet where it ignored the protected areas and only went to the unprotected user cells. 2) If the above cannot be done, how do you turn off that "this sheet is protected" popup? My users will find out they can't change the sheet, but don't want them to get as annoyed as I do when I accidently click the wrong cell. Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection and warning popup
Dave,
thank you for more direction, as above post to Gord, I am now in the ocean of excel, I used to get to play in the wading pool, but no more. Complex forms, programming and lots of interesting set ups are in store for me in this program. The team asks if these ideas can be done, of course I say yes, then scramble to figure out how. -- Continuously think of new ideas and do what it takes to create it, never be afraid to ask if you don''t. "Dave Peterson" wrote: You can't change the message, but you can stop them from selecting locked cells on a protected sheet. Option Explicit Sub auto_open() Dim wks As Worksheet Set wks = Worksheets("sheet1") With wks .Protect password:="hi" .EnableSelection = xlUnlockedCells End With End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ken wrote: I understand how to protect the whole sheet and allow certain cells to be populated. two part question. 1) is there a way to allow the cursor to only spot or start with the unlocked cells? Almost like a fillable PDF? I had an excel sheet where it ignored the protected areas and only went to the unprotected user cells. 2) If the above cannot be done, how do you turn off that "this sheet is protected" popup? My users will find out they can't change the sheet, but don't want them to get as annoyed as I do when I accidently click the wrong cell. Thanks. -- Continuously think of new ideas and do what it takes to create it. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protection and warning popup
Debra Dalgleish has a list of books at her site:
http://www.contextures.com/xlbooks.html John Walkenbach's is a nice one to start with. Depending on how advanced you are... Professional Excel Development By Stephen Bullen, Rob Bovey, John Green See if you can find them in your local bookstore/internet site and you can choose what one you like best. Ken wrote: Dave, thank you for more direction, as above post to Gord, I am now in the ocean of excel, I used to get to play in the wading pool, but no more. Complex forms, programming and lots of interesting set ups are in store for me in this program. The team asks if these ideas can be done, of course I say yes, then scramble to figure out how. -- Continuously think of new ideas and do what it takes to create it, never be afraid to ask if you don''t. "Dave Peterson" wrote: You can't change the message, but you can stop them from selecting locked cells on a protected sheet. Option Explicit Sub auto_open() Dim wks As Worksheet Set wks = Worksheets("sheet1") With wks .Protect password:="hi" .EnableSelection = xlUnlockedCells End With End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ken wrote: I understand how to protect the whole sheet and allow certain cells to be populated. two part question. 1) is there a way to allow the cursor to only spot or start with the unlocked cells? Almost like a fillable PDF? I had an excel sheet where it ignored the protected areas and only went to the unprotected user cells. 2) If the above cannot be done, how do you turn off that "this sheet is protected" popup? My users will find out they can't change the sheet, but don't want them to get as annoyed as I do when I accidently click the wrong cell. Thanks. -- Continuously think of new ideas and do what it takes to create it. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|