@googlegroups.com
Objet : [Norton AntiSpam] $$Excel-Macros$$ Re: Macro for Opening a
Particular Sheet .
Cordial thanks to you for your co operation.
this code is running only if last option of the Macro security is
checked.
ie if enabled all macro ( not recommended..) button is checked
Cordial thanks to you for your co operation.
this code is running only if last option of the Macro security is
checked.
ie if enabled all macro ( not recommended..) button is checked.
if it is so , then some suspicious macro may also be opened that may
affect my file.
kindly sugg
Hi
Use this code
Private Sub Workbook_Open()
Worksheets(3).Activate
End Sub
Jayavelu
9941260857
On Tue, Jun 30, 2009 at 11:46 AM, DEBASHIS BANERJEE
wrote:
>
> I am enclosing herewith an Excel File containing Three Sheet numbering 1 ,2
> and 3.
>
> I like to write a Macro so that only sheet
hi,
in workbook_open write --> Sheets("Sheet3").Activate
Private Sub Workbook_Open()
Sheets("Sheet3").Activate
End Sub
with regards
BALA
On Jun 30, 11:16 am, DEBASHIS BANERJEE wrote:
> I am enclosing herewith an Excel File containing Three Sheet numbering 1 ,2
> and 3.
>
> I
Hi Debashis,
Do as Below :
1. Open the Visual Editor (Alt+F11)
2. Double Click "This Workbook"
3. Paste the below code
Private Sub Workbook_Open()
Sheets("Sheet3").Activate
End Sub
After this, whenever you opened your workbook, sheet3 will be activated.
Regar
