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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel Command Buttons
Thanks, but it is not condusive to my application to use menus. It seems that the buttons only move after the user previews the sheet. I have wrote code to reposition the buttons after the user closes the preview, but that is only a hack. I would like to know how to stop it from happening in the...- kosdav
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Check if file exist
You try my function, and modify as needed: Function WorkBookExists(ByVal vPath As String, vBook As String, Optional msg As String = "Blank") As Boolean ''''''''''''''''''''''''''''''' 'Test to see if a Workbook exists '''''''''''''''''''''''''''''''' If msg = "Blank" Then msg = "Sorry...- kosdav
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel Command Buttons
I have a set of worksheets that I have buttons on. I have the buttons set to not print, and not move or resize wiht cells. The problem is when I preview the worksheet the buttons move to whereever they like when I close the print preview. Any ideas as to how to stop this button movement? I am...- kosdav
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
