Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making macro
To make a macro that if I selected sheet2 , sheet1 hide
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making macro
Private Sub Worksheet_Activate()
Worksheets("Sheet1").Visible = xlSheetHidden End Sub 'This is worksheet event code, which means that it needs to be 'placed in the Sheet2 worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "George A. Jululian" <George A. wrote in message ... To make a macro that if I selected sheet2 , sheet1 hide |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making macro
Right click on the tabl for sheet 2 and select View Code. Paste the following
code... Private Sub Worksheet_Activate() Sheets("Sheet1").Visible = xlSheetHidden End Sub -- HTH... Jim Thomlinson "George A. Jululian" wrote: To make a macro that if I selected sheet2 , sheet1 hide |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making macro
Thank you very much for your help
I want the macro run as soon as I select sheet2 sheet1 to be hide regards "Bob Phillips" wrote: Private Sub Worksheet_Activate() Worksheets("Sheet1").Visible = xlSheetHidden End Sub 'This is worksheet event code, which means that it needs to be 'placed in the Sheet2 worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "George A. Jululian" <George A. wrote in message ... To make a macro that if I selected sheet2 , sheet1 hide |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making macro
Thank you very much for your help
I want the macro run as soon as I select sheet2 sheet1 to be hide regards "Jim Thomlinson" wrote: Right click on the tabl for sheet 2 and select View Code. Paste the following code... Private Sub Worksheet_Activate() Sheets("Sheet1").Visible = xlSheetHidden End Sub -- HTH... Jim Thomlinson "George A. Jululian" wrote: To make a macro that if I selected sheet2 , sheet1 hide |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making macro
please ignore my previous massage your massage was very clear and very
helpful thanks again "Bob Phillips" wrote: Private Sub Worksheet_Activate() Worksheets("Sheet1").Visible = xlSheetHidden End Sub 'This is worksheet event code, which means that it needs to be 'placed in the Sheet2 worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "George A. Jululian" <George A. wrote in message ... To make a macro that if I selected sheet2 , sheet1 hide |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making macro
please ignore my previous massage your massage was very clear and very
helpful thanks again "Jim Thomlinson" wrote: Right click on the tabl for sheet 2 and select View Code. Paste the following code... Private Sub Worksheet_Activate() Sheets("Sheet1").Visible = xlSheetHidden End Sub -- HTH... Jim Thomlinson "George A. Jululian" wrote: To make a macro that if I selected sheet2 , sheet1 hide |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making macro
That is what Bob's event code does.
When sheet2 is activated, sheet1 hides. Did you paste the code into the sheet2 module as Bob instructed? Gord Dibben MS Excel MVP On Sat, 21 Jul 2007 07:30:02 -0700, George A. Jululian wrote: Thank you very much for your help I want the macro run as soon as I select sheet2 sheet1 to be hide regards "Bob Phillips" wrote: Private Sub Worksheet_Activate() Worksheets("Sheet1").Visible = xlSheetHidden End Sub 'This is worksheet event code, which means that it needs to be 'placed in the Sheet2 worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "George A. Jululian" <George A. wrote in message ... To make a macro that if I selected sheet2 , sheet1 hide |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a macro always available | Excel Discussion (Misc queries) | |||
help on macro for making chart | Charts and Charting in Excel | |||
making chart using macro | Excel Discussion (Misc queries) | |||
making chart using macro | Excel Discussion (Misc queries) | |||
Making #N/A zero or - | Excel Discussion (Misc queries) |