Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macros Wont Run After Hiding Sheet
Hi
I run Excel 2K I have a table on a wroksheet called SUPPORT SHEET. I use the sheet for various purposes. eg, validation tables, lookup tables etc On a different sheet I have a macro that copies data from the SUPPORT SHEET. The macro works fine until I hide the SUPPORT SHEET, then the macro does not work. Is there a way I can hide the SUPPORT SHEET but the macro I use still work? Thanks John |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macros Wont Run After Hiding Sheet
Two options:
Sub test() Application.ScreenUpdating = False Worksheets("SUPPORT SHEET").Visible = True 'yourcode Worksheets("SUPPORT SHEET").Visible = False Application.ScreenUpdating = True End Sub OR, my preferred method is to change code so it refers to or updates the sheet without activating or selecting the sheet or its content. If you need more specific advice on the latter post further question/s. -- Steve "John Calder" wrote in message ... Hi I run Excel 2K I have a table on a wroksheet called SUPPORT SHEET. I use the sheet for various purposes. eg, validation tables, lookup tables etc On a different sheet I have a macro that copies data from the SUPPORT SHEET. The macro works fine until I hide the SUPPORT SHEET, then the macro does not work. Is there a way I can hide the SUPPORT SHEET but the macro I use still work? Thanks John |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macros Wont Run After Hiding Sheet
Steve
What you have given me will do. It works great...so well done ! and many thanks John "AltaEgo" wrote: Two options: Sub test() Application.ScreenUpdating = False Worksheets("SUPPORT SHEET").Visible = True 'yourcode Worksheets("SUPPORT SHEET").Visible = False Application.ScreenUpdating = True End Sub OR, my preferred method is to change code so it refers to or updates the sheet without activating or selecting the sheet or its content. If you need more specific advice on the latter post further question/s. -- Steve "John Calder" wrote in message ... Hi I run Excel 2K I have a table on a wroksheet called SUPPORT SHEET. I use the sheet for various purposes. eg, validation tables, lookup tables etc On a different sheet I have a macro that copies data from the SUPPORT SHEET. The macro works fine until I hide the SUPPORT SHEET, then the macro does not work. Is there a way I can hide the SUPPORT SHEET but the macro I use still work? Thanks John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
security med-but still wont open with macros | Excel Discussion (Misc queries) | |||
Hiding Macros | Excel Discussion (Misc queries) | |||
Hiding Macros | Excel Discussion (Misc queries) |