New to UserForms, Need details on saving a userform that has a database
to a local drive, for multiple users. Excel 2000. All users XP, would
like for only form to open upon click of icon.


--
gachett
------------------------------------------------------------------------
gachett's Profile: http://www.excelforum.com/member.php...o&userid=29944
View this thread: http://www.excelforum.com/showthread...hreadid=496428

Hi Gatchett

I presumem you mean you have a created an Excell spread sheet which contains
a datebase and have created a userform which manipulates that database in
one or more ways. As you probaly know the userform(s) you create are stored
with the excel at the point of saving the file ; I think thats what you mean

One way to have the form appear when the file is called from say a desk top
icon, is to create a macro ; a work book open event; such as

Private Sub Workbook_Open()
Application.Visible = False
UserForm1.Show : << substitute your userform name here
End Sub

This macro is created with the MS visual basic editor associated with Excel
( I assume you have used that). Here you should left click the this workbook
icon in the VBAproject excell objects pane

This will immediately hide the normal Excel pane ( and all the controls and
menus) while making the userform visible.

While you are creating I suggest you stick a button on your form which
contains the following code as a click event : Application.Visible = True
: This way you will be able to make the whole application visible again.

In relation toyour second item I would have to say sharing Excell files
doesnt work in my experience so I cant help you with that, perhapes some
one esle might.

Do well

N10




"gachett" wrote in
message ...

New to UserForms, Need details on saving a userform that has a database
to a local drive, for multiple users. Excel 2000. All users XP, would
like for only form to open upon click of icon.


--
gachett
------------------------------------------------------------------------
gachett's Profile:
http://www.excelforum.com/member.php...o&userid=29944
View this thread: http://www.excelforum.com/showthread...hreadid=496428

It worked great, what I found out was I cant just send the form i would
have to send the whole wb as an email attachment now I am trying to
write vb to lock part of the form and attach itself to an outgoing
email


--
gachett
------------------------------------------------------------------------
gachett's Profile: http://www.excelforum.com/member.php...o&userid=29944
View this thread: http://www.excelforum.com/showthread...hreadid=496428