Here is the macro the button calls in. I am running Excel 2002.
Range("A3").Select
Application.CutCopyMode = False
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
The other button does not cause the buttons to relocate.
I have two command Buttons on a spreadsheet. After I click on one of the buttons the buttons reposition themselves to the right. How can I stop the buttons from moving around. Thanks!
I need to be able to be able to change the file location of a .prn file to represent where the user may have it mapped on their computer.
With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;I:\PROJECTS\waytd.prn", Destination:=Range("A1"))
Using the thisworkbook.path does not work...
I have a program which I am wanting to send an automatic email. Our Microsoft Outlook is located on an offsite Citrix server. Has anyone worked with this type of event? If so how do I open this from VB?
I have multiple listboxes on a userform to get the users input on what to include in a autofilter list. The listboxes allow for multiple selections. Is there a way to set the first item in the list as the default if nothing is selected?
I am copying text from Excel(2002) to word. When I try to record a macro to paste and resize to fit window, the option to autofitwindow is grayed. However, I can complete the autofitwindow after stopping the macro record. Any help would be appreciated. The text being copied translates into about...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.