Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suppress protection alerts in Excel
I somehow want to turn off the alert-box that always pops up when any
keyboard keystrokes are made in protected cells in a protected worksheet. When a keystroke is made in these protected cells, I want the result to be nothing, a dead keyboard, no pop up -- the user already knows that these are not active entry cells and does not need a pop up reminder. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suppress protection alerts in Excel
I don't think I'm qualified to help but have you tried on error.resume that type a deal. -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=516443 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suppress protection alerts in Excel
One way to turn it off
Application.DisplayAlerts = False However, this will disable other alerts (such as "Are you sure" before you delete a sheet, or when Excel asks you if you want to save before closing the workbook). You could put these event handlers in the ThisWorkbook module to toggle the alerts on/off. By toggling it on before closing, excel will ask if you want to save the workbook before closing if you've not already done so. Of course, if the user tries to close the workbook then cancels through the save changes dialog box and continues to work, alerts will be activated. Private Sub Workbook_Open() Application.DisplayAlerts = False End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.DisplayAlerts = True End Sub "Yohanne the Great" wrote: I somehow want to turn off the alert-box that always pops up when any keyboard keystrokes are made in protected cells in a protected worksheet. When a keystroke is made in these protected cells, I want the result to be nothing, a dead keyboard, no pop up -- the user already knows that these are not active entry cells and does not need a pop up reminder. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suppress protection alerts in Excel
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 Yohanne the Great wrote: I somehow want to turn off the alert-box that always pops up when any keyboard keystrokes are made in protected cells in a protected worksheet. When a keystroke is made in these protected cells, I want the result to be nothing, a dead keyboard, no pop up -- the user already knows that these are not active entry cells and does not need a pop up reminder. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suppress protection alerts in Excel
Excellent: The help note performed exactly what I wanted it to do. Be
advised, however, that the sheet name nomenclature must be precise in terms of upper-case and lower-case. This gave a few initial problems -- the help advice didn't work -- but it was because of the nomenclature issue (i.e., "sheet1" didn't work -- it had to be "Sheet 1", the precise name of my Excel sheet). But I figured that out -- maybe this will help others. Thanks so much!!! "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 Yohanne the Great wrote: I somehow want to turn off the alert-box that always pops up when any keyboard keystrokes are made in protected cells in a protected worksheet. When a keystroke is made in these protected cells, I want the result to be nothing, a dead keyboard, no pop up -- the user already knows that these are not active entry cells and does not need a pop up reminder. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suppress protection alerts in Excel
The name has to match, but case isn't important:
"sheet 1" and "Sheet 1" and "ShEeT 1" would all work Yohanne the Great wrote: Excellent: The help note performed exactly what I wanted it to do. Be advised, however, that the sheet name nomenclature must be precise in terms of upper-case and lower-case. This gave a few initial problems -- the help advice didn't work -- but it was because of the nomenclature issue (i.e., "sheet1" didn't work -- it had to be "Sheet 1", the precise name of my Excel sheet). But I figured that out -- maybe this will help others. Thanks so much!!! "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 Yohanne the Great wrote: I somehow want to turn off the alert-box that always pops up when any keyboard keystrokes are made in protected cells in a protected worksheet. When a keystroke is made in these protected cells, I want the result to be nothing, a dead keyboard, no pop up -- the user already knows that these are not active entry cells and does not need a pop up reminder. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Best possible protection of worksheets in excel | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel file protection? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |