| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populate a userform from a worksheet | Excel Programming | |||
| Populate A Userform ComboBox | Excel Programming | |||
| Populate sheet from userform | Excel Programming | |||
| Populate Userform from another workbook | Excel Programming | |||
| Userform using 3 ranges to populate. | Excel Programming | |||
Linear Mode
