populate userform only
 

I have a w/book ,data is added to w/sheet 1 through a userform.Whenever I am
activating the userform ,it is populating on sheet1.Is there any way to
display only userform,so that users can not view the data of any sheet in
w/book.How to populate userform only.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200904/1

populate userform only
 

Issue this command in the UserForm's Activate event (assuming the user is
allowed to see Sheet1 when the UserForm is not being displayed)...

Worksheets("Sheet1").Visible = False

and you can put this command...

Worksheets("Sheet1").Visible = True

in the UserForm's QueryClose event in order to show the worksheet again.

--
Rick (MVP - Excel)


"tkraju via OfficeKB.com" <u16627@uwe wrote in message
news:94bdb7bbe4ca8@uwe...
I have a w/book ,data is added to w/sheet 1 through a userform.Whenever I
am
activating the userform ,it is populating on sheet1.Is there any way to
display only userform,so that users can not view the data of any sheet in
w/book.How to populate userform only.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200904/1