populate userform only

  • Thread starter tkraju via OfficeKB.com
  • Start date
T

tkraju via OfficeKB.com

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.
 
R

Rick Rothstein

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.
 
Top