Do not show this message again
How do i write a code to display a message box once an excel file is open
(open event) that allows the user to tick a box if they don't want to see this message any more. i'm using Excel 2003. Many thanks Tendresse |
Do not show this message again
Hi Tendresse
You can check a cell value in the workbook and if it is not "no" for example show the msgbox Private Sub Workbook_Open() If Sheets("Sheet1").Range("A1").Value < "no" Then MsgBox "Hi" End If End Sub You can also build a small userform with a tickbox to fill the cell value with this value -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tendresse" wrote in message ... How do i write a code to display a message box once an excel file is open (open event) that allows the user to tick a box if they don't want to see this message any more. i'm using Excel 2003. Many thanks Tendresse |
All times are GMT +1. The time now is 02:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com