Disable Error messages in Excel 97

davegarland · Mar 22nd, 2002, 10:36 AM

We have a worksheet with 2 buttons designed to protect and unprotect an excel worksheet.
When you try to edit the worksheet in Excel 97 when it's protected, an error message
pops up, and it tells the user how to unprotect the sheet. Is it possible
to stop this message coming up? And maybe display a custom message,
explaining that the user needs to use our buttons to unprotect the sheet?

Al Chara · Mar 22nd, 2002, 01:02 PM

How about the following code:

If Err.Number = # Then
Err.Clear
msgbox "Insert your text here"
End If

Substitute the error number that they are getting with #.

davegarland · Mar 25th, 2002, 01:30 AM

Thanks Al
The problem is that this error/dialogue box appears when th eusers are not running any macros so the code which would work in a macro won't work when they're just attempting to alter the sheet; if you see what I mean!
dave

Ivan F Moala · Mar 25th, 2002, 01:54 AM

Quote:

On 2002-03-25 00:30, davegarland wrote:
Thanks Al
The problem is that this error/dialogue box appears when th eusers are not running any macros so the code which would work in a macro won't work when they're just attempting to alter the sheet; if you see what I mean!
dave

Dave
The msg is a excel system msg...there is no
way to circumvent this msg.

Ivan

davegarland · Mar 25th, 2002, 04:02 AM

Thanks Ivan,

I feared as much when I tried out everything I could think of and nothing worked.

It is a shame because that particular dialogue tells the user how to unprotect the sheet but we wanted them to use our buttons in a custom app!

Russell · Mar 25th, 2002, 05:51 AM

Dave

Could you create your own protection using the protection flag?
If you used the Worksheet_change Event or Workbook_sheet change Event to check the protect property of the cell you were changing and then display your own message box.
I don't want to raise your hopes so please could somebody more familiar with VB confirm is this is viable.

Russell

Mar 22nd, 2002, 01:02 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	How about the following code: If Err.Number = # Then Err.Clear msgbox "Insert your text here" End If Substitute the error number that they are getting with #. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 22nd, 2002, 10:36 AM	#1
davegarland New Member Join Date: Mar 2002 Posts: 16	We have a worksheet with 2 buttons designed to protect and unprotect an excel worksheet. When you try to edit the worksheet in Excel 97 when it's protected, an error message pops up, and it tells the user how to unprotect the sheet. Is it possible to stop this message coming up? And maybe display a custom message, explaining that the user needs to use our buttons to unprotect the sheet?

Mar 25th, 2002, 01:30 AM	#3
davegarland New Member Join Date: Mar 2002 Posts: 16	Thanks Al The problem is that this error/dialogue box appears when th eusers are not running any macros so the code which would work in a macro won't work when they're just attempting to alter the sheet; if you see what I mean! dave

Mar 25th, 2002, 04:02 AM	#5
davegarland New Member Join Date: Mar 2002 Posts: 16	Thanks Ivan, I feared as much when I tried out everything I could think of and nothing worked. It is a shame because that particular dialogue tells the user how to unprotect the sheet but we wanted them to use our buttons in a custom app!

Mar 25th, 2002, 05:51 AM	#6
Russell New Member Join Date: Mar 2002 Posts: 39	Dave Could you create your own protection using the protection flag? If you used the Worksheet_change Event or Workbook_sheet change Event to check the protect property of the cell you were changing and then display your own message box. I don't want to raise your hopes so please could somebody more familiar with VB confirm is this is viable. Russell