Dear Gaurav,
Thisworkbook and activeworkbook is same when comes to work but the
difference is thisworkbook will work where the code is written and
activeworkbook will work with active file
On Mon, Mar 9, 2015 at 3:51 PM, Gaurav Devrani
wrote:
> Hi,
>
> I tried working on that.. while I was test
Hi,
I tried working on that.. while I was testing that , nothing such happend
as you said that your other workbook started hidding sheets. Just wanted to
See if you are using activeworkbook instead of thisworkbook. Let me know,
if this is not the issue. I will see what i can do for that. And also
Dears
Any solution, please !
On Mon, Mar 2, 2015 at 11:24 AM, Yahya Muhammad wrote:
>
> Hi Experts
>
> I have an excel workbook, say Workbook1 with a vba on its workbook_open
> event to hide all worksheets except one, as follows:
>
>
> -
Hi Experts
I have an excel workbook, say Workbook1 with a vba on its workbook_open
event to hide all worksheets except one, as follows:
-
Private Sub Workbook_Open()
Dim sh As Worksheet
For Eac
