Self-Deleting Worksheet/UserForm

  • Thread starter Thread starter universal
  • Start date Start date
U

universal

Hello All,

This is my first post here. Please dont roast me if this has already
been aswered somewhere else, or if its really obvious!!

Im building an excel file for third parties to enter data into.
Currently this uses a UserForm that pastes all the data to the "main"
worksheet.

However, I get disturbed constantly by people ringing to ask for
definitions of data required, technical help, etc. These answers are
most in the instructions included with the Excel file that typically
dont get read.

I am therefore thinking of including an FAQ front sheet as a userform
or worksheet that is displayed when first opened. Plainly though this
would become tedious if users had to look at this every time they
opened the file, so I am looking to have the sheet delete/remove/hide
itself for ever once the users have confirmed that they have read it.

Any help would be appreciated,

Thanks

Eddie [Universal]
 
Hi,



You could use the SaveSetting and the GetSetting Statement that will save
information in their Registety to know if they already read it.
 
Jean-Paul, that sounds like a really good way of doing it, thanks.

Just one question, I'm a bit new to all this, how would I go about
this?

Apologies for my ineptitude!

Eddie
 
Hi,



In the code section of your HelpForm put this code:



Private Sub CommandButton1_Click()

SaveSetting "MyApplication", "TheHelpSec", "FormVisibility",
"No"

TheUserForm.Show

End Sub





Private Sub UserForm_Initialize()

If GetSetting("MyApplication", "TheHelpSec", "FormVisibility") = "No"
Then

TheUserForm.Show

Else

The HelpForm.Show

End If

End Sub



When they close it with the button, the value No will be save in the
registry and whet they open it again, if it is not the first time they will
read the value No and go directly to the useful form
 
Back
Top