Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: yoavbs
- Order by date
-
Datagrid Refreshing
Try first closing the recordsourse and the connection to the db, and only after doing that, refresh the adodc or the datagrid that you are using- yoavbs
- Post #2
- Forum: Visual Basic (Classic)
-
Hide all worksheets in excel
Ooppps....forgot to make them "Visiable" for u... Private Sub CommandButton3_Click() Unload Me Application.ScreenUpdating = False For Each Worksheet In Worksheets Worksheet.Visible = True Next Application.ScreenUpdating = True End Sub ....and that's it...[peace]- yoavbs
- Post #9
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Hide all worksheets in excel
Try doing this- First name one of your sheets (one sheet that must contain your workbook) as "Control" and then: Private Sub Workbook_Open() Application.ScreenUpdating = False On Error Resume Next For Each Sheet In ThisWorkbook.Sheets If Sheet.Name <> "Control" Then...- yoavbs
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
