Can you mark it as the answer, in case someone else searches for a similar
problem?

Sam

"Sandy" wrote:

Very simple and works a treat
Thank you
Sandy

"Sam Wilson" wrote in message
...
You could have a sheet in the workbook, and set that sheet's visibility to
very hidden, and then have the event record a 1 in cell A1 on this sheet
if
the checkbox is ticked.

Then you just need to add an if statement before frmWelcome.show in your
workbook open event.

Sam

"Sandy" wrote:

I have created a userform:- name = frmWelcome. On the form I have a
checkbox:- name = cbNoView. The form contains information concerning the
workbook.

What I am trying to do is to have the form open with excel but should the
user not want to see it again then tick the check box, and it will not
open
again.

Can anyone point me in the right direction as to the code requirement and
where it would be placed.

Excel 2003

Sandy