P Paulo de Arruda Borelli Sep 9, 2004 #1 How can I change the active sheet's tabs? (the ones named "Plan1", "Plan2" etc. by Excel) Thank you Paulo.
How can I change the active sheet's tabs? (the ones named "Plan1", "Plan2" etc. by Excel) Thank you Paulo.
P Peter Huang Sep 9, 2004 #2 Hi Paulo, You may try to use the code below. Sub Test() Dim ws As Worksheet Set ws = Application.ActiveSheet ws.Name = "hello" End Sub Best regards, Peter Huang Microsoft Online Partner Support Get Secure! - www.microsoft.com/security This posting is provided "AS IS" with no warranties, and confers no rights.
Hi Paulo, You may try to use the code below. Sub Test() Dim ws As Worksheet Set ws = Application.ActiveSheet ws.Name = "hello" End Sub Best regards, Peter Huang Microsoft Online Partner Support Get Secure! - www.microsoft.com/security This posting is provided "AS IS" with no warranties, and confers no rights.
P Peter Huang Sep 13, 2004 #3 Hi Paulo, If you still have any concern on this issue, please feel free to post here. Best regards, Peter Huang Microsoft Online Partner Support Get Secure! - www.microsoft.com/security This posting is provided "AS IS" with no warranties, and confers no rights.
Hi Paulo, If you still have any concern on this issue, please feel free to post here. Best regards, Peter Huang Microsoft Online Partner Support Get Secure! - www.microsoft.com/security This posting is provided "AS IS" with no warranties, and confers no rights.