try this add this in thisworkbook module
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheet1.Activate
ThisWorkbook.Save
End Sub
Private Sub Workbook_Open()
Sheet1.Activate
End Sub
On Thu, Aug 1, 2013 at 4:40 PM, अनिल नारायण गवली wrote:
> Dear All,
>
> Pls see the attached sheet.
>
>
Sorry ignore my last email, i just opening the macros code in your
workbook, and find that you have do it right, but in wrong place
Try to place that code in ThisWorkbook not in Sheet1
Pada 01/08/2013 17:34, De Premor menulis:
Hi Hemal, in your first email you said:
*I want that, Menu sheet is
Thanks.
On Thursday, 1 August 2013 16:04:01 UTC+5:30, suman kumar wrote:
>
> Hi
> You should use below code in "ThisWorkbook" in OPEN event. Please find the
> attached file now its working as well.
>
>
>
>
>
>
>
>
>
> *Suman Kumar*
>
>
> On Thu, Aug 1, 2013 at 3:53 PM, he
Hi Hemal, in your first email you said:
*I want that, Menu sheet is to be open every time when I open excel file.*
Thaat why Priti give a code like this !
Worksheets("Menu").Activate
But in your real workbook, you dont have a sheet named *"Menu"*m but you
have sheet named "*INDEX*"
Try to chan
Hi Priti,
it is not working
On Thu, Aug 1, 2013 at 3:05 PM, priti verma wrote:
> you can use workbook open event to active worksheet
> Private Sub Workbook_Open()
> Worksheets("Menu").Activate
> End Sub
>
>
>
> On Thu, Aug 1, 2013 at 2:23 AM, hemal shah wrote:
>
>>
>> I have 3 sheets in my e
you can use workbook open event to active worksheet
Private Sub Workbook_Open()
Worksheets("Menu").Activate
End Sub
On Thu, Aug 1, 2013 at 2:23 AM, hemal shah wrote:
>
> I have 3 sheets in my excel book.
>
> First sheet is Menu sheet.
>
> I want that, Menu sheet is to be open every time when I
Hi Hemlal,
You can use below code:
Private Sub Workbook_Open()
Application.Sheets("sheet1").Select
End Sub
*Suman Kumar*
On Thu, Aug 1, 2013 at 2:53 PM, hemal shah wrote:
>
> I have 3 sheets in my excel book.
>
> First sheet is Menu sheet.
>
> I want that, Menu sheet is to be open ev
